Forum Discussion
Matrix table not calculate correct total
In this we calculate last 12 month sales, but for Dec 2019 we need to get sales from 1st dec 2019 to as according to Current day for example today is 11th dec 2020 (1st dec 2019 to 11 dec 2019) and so on and current year YTD i.e (1st Jan 2020 to Current day ), so for achieving this we create two measure one is calculate for Dec 2019 (1st dec 2019 to 11 dec 2019) only and another one is used to calculate current year YTD and then we combine the both result but after implement this we are not getting correct total, it is used only Dec 2019 sales amount as total value, as seen in the above screenshot,we need to calculate total for all 12 months data including dec 2019 as well. Kindly help me on this .how can i acheive this ?
Hi Anonymous ,
Please try to create another new measure as below to replace the measure [Net Sales] in matrix:
Measure = SUMX ( VALUES ( 'Table'[Period] ), [Net Sales] )If it is not working, you can share the applied fields or measure in your matrix and the formula of measure [Net Sales], later we will provide you a suitable solution. Or you can also refer the method in the following links.
Obtaining accurate totals in DAX
Dax for Power BI: Fixing Incorrect Measure Totals
Why Your Total Is Incorrect In Power BI - The Key DAX Concept To Understand
Best Regards
1 Reply
Hi Anonymous ,
Please try to create another new measure as below to replace the measure [Net Sales] in matrix:
Measure = SUMX ( VALUES ( 'Table'[Period] ), [Net Sales] )If it is not working, you can share the applied fields or measure in your matrix and the formula of measure [Net Sales], later we will provide you a suitable solution. Or you can also refer the method in the following links.
Obtaining accurate totals in DAX
Dax for Power BI: Fixing Incorrect Measure Totals
Why Your Total Is Incorrect In Power BI - The Key DAX Concept To Understand
Best Regards