Calculate Grand % of value

[ViralPatel212]

Hello Guys,

I am trying to create a measure to calculate the "Grand % percentage". I did create a measure called 0-1MM and when i add that information into the table and right-click and choose "show value as Pe" i am getting the correct values and the total is 100%.

You can access the Sample file here: Sample File 

The process here is that a end client would select a venue and in the second table is will give them a breakdown per client. 

I did attempt to create the % measure as the following: 

Client 0-1 % =
VAR _current =
CALCULATE(
    [Ranking Size (Vol)], 'Dealer Ranking'[Size (€MM Bucket)] = 2)
VAR _allvol =
CALCULATE([Ranking Size (Vol)], ALL('Dealer Ranking'[Size (€MM Bucket)]))
RETURN
DIVIDE(_current,_allvol)

but for some reason this is not giving me as total 100% and the values is not matching the column where i did "Show value as grand percentage".

[ViralPatel212 · Accepted solution]

@Anonymous 

Thank you for the advice, i have amended the data 🙂

Also i have resolved it, turns out i needed to get the grand row % which i have done

[Anonymous]

Hi @ViralPatel212 ,

You need to desensitize the data you provide or there may be a security risk.

Best regards,

Adamk Kong