I have a situation where I am summing the sales for all products in my Fact table across all time periods.
From SQL side, I am writing the query below and getting the expected result;
ProductName, SUM(SaleAmount) AS SaleAmount
GROUP BY ProductName
However when i write this in DAX and place the SalesAmount by ProductName on a table visual in power bi, the SalesAmount are being assigned to a different product like so;
The DAX formula I am using is
SalesAmount = SUM(dbo.FactSales[SaleAmount])
What could be the reason for the SalesAmount being assigned to a different product on the table visual in Power BI.