Need help with calculations

[Jyo27]

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

[Anonymous · Accepted solution]

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