Forum Discussion

Gofin's avatar
Gofin
Regular Visitor
2 years ago
Solved

Need help in calculations

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

 
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    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

     

1 Reply

  • Ritaf1983's avatar
    Ritaf1983
    Icon for Super User rankSuper User
    2 years ago

    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