Different sales amount number for the same quarter
After applying the new table with customized hierarchy, WHY the sales of the third Qtr is 15.6 K although when using the "Ask Question" of Power BI the third Qtr sales showed different number 7,670,590.20
1 answers ( 0 marked as helpful)
It is hard to tell from the screenshots, there could be several reasons. First one is the date, on the second screenshot you are using dim_Date, on the first one you are using Due Date maybe? Second is the measure, you are using the SalesAmount on one chart on the other one is TotalSales. And the third possibility is the relationship between the two tables.