Forum Discussion
Solved
Incorrect total
Best regards! Help! Help! I have this case, each item has a budget and real sale per month, to calculate the adhesion I have to condition, if the budget is greater than the shipping, then the shippi...
Hi Syndicate_Admin ,
I created some data:
When the total is incorrect:
Here are the steps you can follow：
1. Create measure.
Total is correct = var _table=SUMMARIZE('Table','Table'[Group],"_value",[Total is incorrect]) return IF(HASONEVALUE('Table'[Month])&&HASONEVALUE('Table'[Group]),[Total is incorrect],SUMX(_table,[_value]))2. Result:
If you need pbix, please click here.
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
Hi Syndicate_Admin ,
I created some data:
When the total is incorrect:
Here are the steps you can follow：
1. Create measure.
Total is correct =
var _table=SUMMARIZE('Table','Table'[Group],"_value",[Total is incorrect])
return
IF(HASONEVALUE('Table'[Month])&&HASONEVALUE('Table'[Group]),[Total is incorrect],SUMX(_table,[_value]))2. Result:
If you need pbix, please click here.
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