Need help in calculations

[Gofin]

Hi everyone,

Based on Name filter selection ,How to calculate this ratio? Please help with dax measures or column formulas .

For example : if Name 'A' ,'B'  is selected in the slicer, then ratio for name 'A' will be 1/34 = 0.029 and for name 'B' will be 1/34 = 0.029.Here 34 is A+B = 12+22

 

Name  qty  count     Ratio
A        12      1           0.014493
B        22       1           0.014493
C       13       2             0.028986
D       22      4              0.057971
Total 69

[Ritaf1983 · Accepted solution]

Hi @Gofin 
You can use 3 measures :

sum _QTY = sum('Table'[QTY])

sum_Count = sum('Table'[Count])

Ratio = divide ([sum_Count],CALCULATE([sum _QTY],ALLSELECTED('Table'[Name])))

You can download the pbix from this link 

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