Running Total for Measure based on 2 columns not able to calculate

[Anonymous]

IN the above image i need to calculate running percentage for Sum(conti/cost). Sum(conti/cost) is a measure:

Sum(conti/cost) = DIVIDE(SUM(Raw_Data_V1[Contingency$]), SUM(Raw_Data_V1[Cost]))

Dax Measure used which is not giving expected result

Sum(conti/cost) running total in Close_Month =

var runningtotal = CALCULATE(

    [Sum(conti/cost)],

    FILTER(

        ALLSELECTED('Raw_Data_V1'[Close_Month]),

        ISONORAFTER('Raw_Data_V1'[Close_Month], MAX('Raw_Data_V1'[Close_Month]), ASC)

    ))

Return

if('Measure Tables'[Sum(conti/cost)]=BLANK(),BLANK(),runningtotal)

Need a help

[Anonymous · Accepted solution]

Hi  @Anonymous ,

If you want to get the cumulative total of [Sum(conti/cost)], you can use the following dax:

Measure =
SUMX(FILTER(ALL(Raw_Data_V1),
'Raw_Data_V1'[MonthNumber]<=MAX('Raw_Data_V1'[MonthNumber])),[Sum(conti/cost)])

If the total at the bottom of the table is incorrect, you can use the HASONEVALUE function when creating a dax:

Total is correct =
var _table=SUMMARIZE('Raw_Data_V1','Raw_Data_V1'[MonthNumber],"_value",[Measure])
return
IF(HASONEVALUE('Raw_Data_V1'[MonthNumber]),[Measure],SUMX(_table,[_value]))

If I have misunderstood your meaning, please provide your desired output and your pbix without privacy information.

Best Regards,

Liu Yang

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

[Anonymous]

Thank You very much this works !! all the way