Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a measure which selects values using two other measures depending on a third measure.
Measures are: Actual Days, Potential days and Latest Actuals Period. Actual days is only available up to the current period because after that is the future. So my measure is as follows:
What have I done wrong?
Thank you
@IntaBruce First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e
This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8
Hey @IntaBruce ,
consider wrapping SUMX around your existing expression like so:
measure =
sumx(
values(<the column you are using on the rows of the matrix visual>)
, <your expression>
)
Hopefully, this helps to tackle your challenge.
Regards,
Tom
User | Count |
---|---|
86 | |
82 | |
68 | |
64 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |