Forum Discussion
DAX Cumulative Measures not Correct
- 3 years ago
Side effects of the Sort By Column setting in DAX - SQLBI
Cumulative Commission Payment = CALCULATE( [Commission Payment], 'Date Table'[Month] <= MAX( 'Date Table'[Month] ), REMOVEFILTERS( 'Date Table'[Month Name] ) ) - 3 years ago
Thank you so much. Worked like a charm. However, I don't want to show cumulative for months that have BLANKS measures. For example, Table 7 in data check (Termed Subscribers by Month) I still get cumulative for April & July where there were no Termed Subscribers! Also, for me to undrestand the logic behind your DAX for cumulative, how does it work to have
'Date Table'[Month] <= MAX('Date Table'[Month]), but in REMOVEFILTER, you haveREMOVEFILTERS('Date Table'[Month Name])?Thank you,Helal - 3 years ago
You are welcome. Not sure of what you mean. Please share some data and show the expected result. If your FY is other than 31 December, then you can specify that in the second input of the DATESYTD function.
Thank you again Ashish. Just a quick question. The
- Ashish_Mathur3 years ago
Super User
You are welcome. Not sure of what you mean. Please share some data and show the expected result. If your FY is other than 31 December, then you can specify that in the second input of the DATESYTD function.