Forum Discussion
Measure Total
I'm new to DAX and have tried every solution I could find to calculate the correct total for Move-Out without any luck. All the suggested solutions always returned the same -1,411 as below. Cha...
Hi Brad_Roberts ,
Are you referring to the incorrect Total value of the yellow label.
You can create a Measure, use HASONEVALUE and IF to make judgments, and make sure Total is correct.
Here are the steps you can follow：
1. In Power query. Add Column – Index Column – From 1.
2. Create measure.
Total =
var _table1=SUMMARIZE('Table', 'Table'[Index],"Value",[Test Move-out])
return
IF(
HASONEVALUE('Table'[Index] ),
[Test Move-out],SUMX(_table1,[Value]))3. 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
Liu Yang,
When I go to add the index, not all of my rows get a value. Start SF is measure based off of an inactive relationship. This seems to be my issue, all the DAX functions I have tried don't recongize those rows.