Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

cumulative sum issue

Hi, I have the following problem: I have used the following measure to calculate the cumulative sum:   This should be the sum of entries in the table:    mit IV = DISTINCTCOUNT(Kunde[amsidnr]) ...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi Anonymous,

     

    This measure should work.

    IV = 
CALCULATE (
KUNDE[mit IV],
FILTER(
ALLSELECTED(KUNDE),
KUNDE[INSERTDATE] <= MAX(KUNDE[INSERTDATE])
))

    Best regards,

    Yuliana Gu

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
7 years ago
Anonymous wrote:
The formula works fine, but when I use the measure in a graph it shows me all the upcoming months for this year with the value being the same. I only want to see the graph for the monthsuntil now. The slicers don't seem to work. I have no data for the months after January 2019. 

 

Anonymous

What measure are you referring to? You say they are all calculated columns

Anonymous's avatar
Anonymous
Not applicable
7 years ago

AlB I am sorry

 

mit IV and IV are measures

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I use IV in a graph with INSERTDATE being the x-axis