% Ratio With two level vs Principal Parent

[mrbajana]

A formula that shows me the ratio of the levels below on the first level as image.  I have only 3 levels the second is correct but in the third level I need compare the ratio vs the first level and not the second. Example 1 Divide to 345 , 14 Divide to 345 a so on.

Thanks a Lot

[v-zhangti · Accepted solution]

Hi, @mrbajana 

I've simulated some data that I hope fits your situation.

Total = COUNT([Bancos-3])

Ratio = 
Var N1=CALCULATE(COUNT('Table'[Bancos-3]))
Var N2=CALCULATE(COUNT('Table'[Bancos-3]),ALL('Table'))
return
DIVIDE(N1,N2)

Is this the output you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.