Forum Discussion

Jyo27's avatar
Jyo27
Icon for Helper II rankHelper II
2 years ago
Solved

Need help with calculations

Hi ,

 

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 qtycountRatio
A1210.014493
B2210.014493
C1320.028986
D2240.057971
Total69  
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    HI Jyo27,

    You can try to use following measure formula if it suitable for your requirement:

    formual =
CALCULATE (
    SUM ( Table1[qty] ),
    ALLSELECTED ( Table1 ),
    VALUES ( Table1[Name] )
)

    Regards,

    Xiaoxin Sheng

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    HI Jyo27,

    You can try to use following measure formula if it suitable for your requirement:

    formual =
CALCULATE (
    SUM ( Table1[qty] ),
    ALLSELECTED ( Table1 ),
    VALUES ( Table1[Name] )
)

    Regards,

    Xiaoxin Sheng