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

     
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