Forum Discussion

vjnvinod's avatar
vjnvinod
Icon for Impactful Individual rankImpactful 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()
    )

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi, vjnvinod 

 

As AnkitaaMishra  said, you can try the following formula.

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

Is this the result you expected?

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.