cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

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

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team

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

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,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team

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

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,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Frequent Visitor

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

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