Forum Discussion
Solved
DAX Measure not summing correctly
Hi All, Apologies if this is solved elsewhere. I have 2 data sets related by date. The first data set contains an Actual amount, the second data set contains a forecast amount. What I need to ...
Hi All,
A little more searching and I found a solution.
Thanks Greg_Deckler.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
the solution I used:
Measure1 = VAR __table = SUMMARIZE('Date',[Date],"__value",[Measure]) RETURN IF(HASONEVALUE('Date'[Date]),[Measure],SUMX(__table,[__value]))
Hi All,
A little more searching and I found a solution.
Thanks Greg_Deckler.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
the solution I used:
Measure1 =
VAR __table = SUMMARIZE('Date',[Date],"__value",[Measure])
RETURN
IF(HASONEVALUE('Date'[Date]),[Measure],SUMX(__table,[__value]))