Forum Discussion

DataStraine's avatar
DataStraine
Icon for Advocate I rankAdvocate I
5 years ago
Solved

Cumulative Sum When Not Desired?

Hello all. I'm very new to Power BI and I'm stumped. I am trying to wirte a calculation to determine where a customer is considered churned on their 7th month of inactivity. I have calculations for I...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    There should definitely be Month name in the visual for the measure to get a row context.  Write this additional measure and drag it to your matrix visual

    Measure 2 = SUMX(GENERATE(VALUES('Calendar'[Month name]),VALUES('Calendar'[Year])),[Measure])

    You may drag the Customer Name off the matrix, if you so wish

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

There should definitely be Month name in the visual for the measure to get a row context.  Write this additional measure and drag it to your matrix visual

Measure 2 = SUMX(GENERATE(VALUES('Calendar'[Month name]),VALUES('Calendar'[Year])),[Measure])

You may drag the Customer Name off the matrix, if you so wish

DataStraine's avatar
DataStraine
Icon for Advocate I rankAdvocate I
5 years ago

Thank you so much for helping with this! Sorry to keep going without accepting the soultion, and this is on me for not making my post clear enough. So this works for getting the year values....

Edit - Nevermind it does produce the right soultion when use in a bargraph chart, which was the goal. Thank you!  However, I'm having a really hard time understanding  why the original forumual you wrote doesn't get what I expected for the filter context already. Do you mind explaining why it wasn't able to find the counts on a year granularity without the SUMX of counts?

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    5 years ago

    You are welcome.  To go back 7 months, it will need a month row context.  Therefore month has to be dragged to the visual.