Forum Discussion
TOTALYTD with 3 Measures
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!
2 Replies
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