Solved: Running total with IF statement?

Sparkeltje · ‎04-18-2021

Hi guys,

Struggeling with a running total. I only want a running total if slicer selection is the same as a column in my table.

For example:

Slicer = FISCALYEAR

Then I only want a running total of all values/fiscalyears where column DP_YEAR is the same als the slicer(FISCALYEAR).

ASSET_ID 11287 returns IF slicer FISCALYEAR = 2020

-8191731

and when FISCALYEAR = 2021 then 0

ASSET_ID 11293 returns IF slicer FISCALYEAR = 2020

0

and when FISCALYEAR = 2021 then

-309466

Thank you for you help.

Sparkeltje · ‎04-23-2021

Thank you for your reply, the following DAX solved my problem.

RT_DP_YEAR =

VAR FISCALYEAR = SELECTEDVALUE('table'[FISCALYEAR])

RETURN

CALCULATE(SUMX('table',

'table'[AMOUNT]),

FISCALYEAR = 'table'[DP_YEAR],

ALL('table'[FISCALYEAR]))

lbendlin · ‎04-18-2021

Running total needs something that it can sort by. it is not clear from your data which column is suitable for sorting. Please elaborate.

Sparkeltje · ‎04-23-2021