cancel
Showing results for
Did you mean:
Helper I

## Divide filtered value by (non filtered) total

Hello,

I need help in something that might be simple.

I have a table with "total transactions per hour" in one column and "50% of the transactions per hour" in another column, something similar to this:

HOUR        TOT       50%

3pm          208       104

4pm          212       106

5pm          218       109

Total         638       319

I have to create another column with the percentage of the 50% of transactions per each hour over the total (638). In other words, i need the following:

104 / 638

106 / 638

109 / 638

Any help would be greatly appreciated.

thanks!

2 ACCEPTED SOLUTIONS
Super User I

You should be apple to add another column as:

```% =
DIVIDE ( TableName[50%], SUM ( TableName[TOT] ), 0 )```

Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!

Community Support

You may add the measure below.

```Measure 2 =
DIVIDE (
[50%],
CALCULATE ( SUM ( 'Table'[TOT] ), ALLSELECTED ( 'Table'[HOUR] ) )
)
```
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
Super User I

You should be apple to add another column as:

```% =
DIVIDE ( TableName[50%], SUM ( TableName[TOT] ), 0 )```

Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!

Helper I

thanks.

but the challenge is that the "50% transactions" is not a straight calculation from "tot transactions", but the result of SELECTEDVALUE from a filter...

Community Support

You may add the measure below.

```Measure 2 =
DIVIDE (
[50%],
CALCULATE ( SUM ( 'Table'[TOT] ), ALLSELECTED ( 'Table'[HOUR] ) )
)
```
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper I

thanks a lot  , this is exactly what i was looking for!

Announcements

#### Happy New Year from Power BI

This is a must watch for a message from Power BI!