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.
I have 3 measures, that all have different filters to get to particular values for a period of time (month, in this case). When I try to take all 3 measures to create a cumulative running total, or YTD, calculation, it will not work. Essentially, we have a period of time where Amount1 + Amount2 have a gap in-between, so we have to substitute Amount3 in for that particular month. Each of the 3 measures are wrapped in TOTALYTD function. I do have a date dimension as well. Amount1 and Amount2 calculation TOTALYTD corretly, but....
What seems to be happening in DAX, is when it tries to do TOTALYTD on Amount 3, it returns blank, so when the AmountYTD measure calculates, it ignores that month. I've been fighting this for several days, and am stumped! Anyone have any ideas? I consider myself a pretty advanced DAX coder, but I've tried 100s of combinations to get this to calculation corretly, and it simly will not.
Your help/suggestions is much appreciated!
https://pasteboard.co/GBwaelS.png
Solved! Go to Solution.
My issue was with one of my measures, not the fact that only one value was being returned. This is resolved.
Hi @Anonymous,
It will be help if you share some detail content of your requirement.(for instance, sample data , measures formulas)
In addition, if you want the slicer works on measure , please ensure you are add the 'allselected' function to active the slicer effect on these measures.
Regards,
Xiaoxin Sheng
My issue was with one of my measures, not the fact that only one value was being returned. This is resolved.
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 |
---|---|
117 | |
107 | |
70 | |
70 | |
43 |
User | Count |
---|---|
148 | |
106 | |
104 | |
89 | |
65 |