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

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