Calculating % of Total Running Sum along Table (Across), Converting Calculation from Tableau to DAX

[Anonymous]

I am trying to convert an equation I am using in Tableau to DAX. It is to show a running percent of total in relation to a distribution (distribution is daily and goes by hour, so for example at midnight this % would be near or at 100%). In Tableau the calculation is: RUNNING_SUM(SUM([X])) / TOTAL(SUM([X])). I am wondering how to replicate this in DAX or if there is even possibly an easier solution I am not aware of. Any help would be greatly appreciated.

[v-cherch-msft · Accepted solution]

Hi @Anonymous 

You may try to create measures like below:

Cumulative Hours =
CALCULATE (
    SUM ( 'Table'[hours] ),
    FILTER ( ALL ( 'Table' ), 'Table'[Time] <= MAX ( 'Table'[Time] ) )
)

Measure =
[Cumulative Hours] / CALCULATE ( SUM ( 'Table'[hours] ), ALL ( 'Table' ) )

Regards,

[Anonymous]

Thank you that equation was exactly what I was looking for! @v-cherch-msft