cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
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
Super User I

@el_dido -

You should be apple to add another column as:

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

98.PNG






Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!



View solution in original post

@el_dido 

 

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.

View solution in original post

4 REPLIES 4
Super User I
Super User I

@el_dido -

You should be apple to add another column as:

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

98.PNG






Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!



View solution in original post

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...

@el_dido 

 

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.

View solution in original post

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

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

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

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors