Divide filtered value by (non filtered) total

[Anonymous]

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!

[ChrisMendoza · Accepted solution]

@Anonymous -

You should be apple to add another column as:

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

[ChrisMendoza · Accepted solution]

@Anonymous -

You should be apple to add another column as:

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

[Anonymous]

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

[v-chuncz-msft · Accepted solution]

@Anonymous 

You may add the measure below.

Measure 2 =
DIVIDE (
    [50%],
    CALCULATE ( SUM ( 'Table'[TOT] ), ALLSELECTED ( 'Table'[HOUR] ) )
)

[Anonymous]

thanks a lot v-chuncz-msft , this is exactly what i was looking for!