Forum Discussion

helalm's avatar
helalm
Icon for Helper II rankHelper II
3 years ago
Solved

DAX Cumulative Measures not Correct

Greetings, I need help to figure out what’s wrong with counts & cumulative counts/sum over month. The enclosed Power BI file (https://drive.google.com/file/d/16k0GXPgO5QQXNZC-CvVudO9FmcAJLDut/view?u...
  • helalm's avatar
    helalm
    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 have 
    REMOVEFILTERS('Date Table'[Month Name])?
     
    Thank you,
    Helal
  • Ashish_Mathur's avatar
    Ashish_Mathur
    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.