Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ?
Solved! Go to Solution.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.