Forum Discussion
Total not Correct
Hello Freinds,
I've being struggling with a relative simple and recurrent problem I believe.. I Have a set of measures and results inside the table are ok, although the total is not correct.
I've tried summarize and other formulas with no success.. Can someone help me? 🙂
best regards
Hi joao_maia_ext ,
You can use HASONEVALUE to resolve incorrect totals.
Here are the steps you can follow：
1. According to your description, I created sample data.
2. First, suppose you have a measure and find that the sum calculated by this metric is incorrect.
Measure_Sum = IF(SUM('Table'[Amount])<1000,0,SUM('Table'[Amount]))3. Then to calculate the sum, you can create a measure.
Calculate Sum = var Table1=SUMMARIZE('Table','Table'[Date],"_value",[Measure_Sum]) return IF(HASONEVALUE('Table'[Date]),[Measure_Sum],SUMX(Table1,[_value]))4. Result.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
4 Replies
Hi joao_maia_ext ,
Check this existing thread for a solution given by Greg_Deckler .
https://community.powerbi.com/t5/Desktop/Total-of-measure-is-wrong/m-p/367260
Thanks,
Pragati
Thank you for the reply! Can you identify which thread? 🙂
Hi joao_maia_ext ,
You can use HASONEVALUE to resolve incorrect totals.
Here are the steps you can follow：
1. According to your description, I created sample data.
2. First, suppose you have a measure and find that the sum calculated by this metric is incorrect.
Measure_Sum = IF(SUM('Table'[Amount])<1000,0,SUM('Table'[Amount]))3. Then to calculate the sum, you can create a measure.
Calculate Sum = var Table1=SUMMARIZE('Table','Table'[Date],"_value",[Measure_Sum]) return IF(HASONEVALUE('Table'[Date]),[Measure_Sum],SUMX(Table1,[_value]))4. Result.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
