Forum Discussion

mafioso's avatar
mafioso
Helper II
8 years ago

Measure doesn't summarize properly

This is my table:     I don't know why, but the cross total at the bottom is right although the values in some cols are wrong. You can calculate by yourself, the result for nearly every colu...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

Hi mafioso,

 

Modify DAX formula like below and check if it can work:

M_C running total in Date =
CALCULATE (
    [M_E];
    FILTER ( Master; ISONORAFTER ( 'Master'[Date]; MAX ( 'Master'[Date] ); DESC ) );
    ALLSELECTED ( 'Master'[Date] )
)

Regards,

Jimmy Tao

  • mafioso's avatar
    mafioso
    Helper II
    8 years ago

    Thanks for your answer but that is not really the answer i was looking for. I want to have a cumulative total by year and somehow some values are not counting. Your solution gives me the correct numbers, now I need to summarize them.

    For example:

    2018: 5 (5)

    2019: 9 (4)

    2020: 16 (7)

    2021: 20 (4)

  • mafioso's avatar
    mafioso
    Helper II
    8 years ago

    v-yuta-msft Ok i finally found the problem. Can you help me to fix it? 

    I marked the lines red. I need the value from 2019 in every other column.

    So I want it to look like that:

    -256 -768 -768 -768 -768 -768

     

     

    • v-yuta-msft's avatar
      v-yuta-msft
      Community Support
      8 years ago

      Hi mafioso,

       

      What's the logic of values you want to achieve from "2019 in every other column"? Could you give more details about your table and measure you are using and also more details about your expected requirement?

       

      Regards,

      Jimmy Tao