Forum Discussion

vjnvinod's avatar
vjnvinod
Impactful Individual
1 year ago
Solved

Dax Logic Help for cumulative on Card

  problem statement: my actuals. measure in the table shows cumulative value, but when i place the same measure on the card, i get that individual value of the month, as you can see in Feb its 50M a...
Need Help
Show and Tell
  • AnkitaaMishra's avatar
    AnkitaaMishra
    1 year ago

    Hi vjnvinod , I tried to replicate your problem statement and below formula is working for me. 

    Just change the ALLSELECTED to ALL in your case.

    IF([Actuals]>0,
    CALCULATE(
        [Actuals],
            ALL('GroupOPEXCAPEX'),
            'GroupOPEXCAPEX'[DateColumn] <= MAX('GroupOPEXCAPEX'[DateColumn]) &&
            'GroupOPEXCAPEX'[Actual/Budget] = "Actuals"
        ),BLANK()
    )

anmolmalviya05's avatar
anmolmalviya05
Super User
1 year ago

Hi vjnvinod, Please try this:

Total Cumulative Value =
CALCULATE(
SUMX(
ALLSELECTED('GroupOPEXCAPEX'[DateColumn]),
[Actuals]
),
'GroupOPEXCAPEX'[Actual/Budget] = "Actuals"
)