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.
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 do is create a calculated column that ignores the Forecast value if an Actual value is present, but when an Actual value is not present displays the Forecast value. I have done this with the following measure:
Measure = if(ISblank(Sum('Actual'[Act])),Sum(Forecast[Forecast]),sum(Actual[Act]))
The issue is that the measure column fails to Sum correctly.
The highlighted value should read the same as the Forecast column, but it appears only the first 3 values are being summed?
is anyone able to assist in highlighting what I need to do to have this measure column calculate correctly.
Cheers
Brad
Solved! Go to Solution.
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]))
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.
User | Count |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
44 | |
32 | |
30 | |
18 | |
17 |