Forum Discussion
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!
Anonymous -
You should be apple to add another column as:
% = DIVIDE ( TableName[50%], SUM ( TableName[TOT] ), 0 )
Anonymous
You may add the measure below.
Measure 2 = DIVIDE ( [50%], CALCULATE ( SUM ( 'Table'[TOT] ), ALLSELECTED ( 'Table'[HOUR] ) ) )
4 Replies
- ChrisMendoza
Resident Rockstar
Anonymous -
You should be apple to add another column as:
% = DIVIDE ( TableName[50%], SUM ( TableName[TOT] ), 0 )
v-chuncz-msftCommunity Support
Anonymous
You may add the measure below.
Measure 2 = DIVIDE ( [50%], CALCULATE ( SUM ( 'Table'[TOT] ), ALLSELECTED ( 'Table'[HOUR] ) ) )