Dynamic measure based on selected slicer value

[mjmjn2611]

Hi,

I need to create a dynamic measure 

Product group   Category  Measure

1                        A 
1                        B

2                        A

2                        B

When I choose only product group 1, then the measure applied for both category A & B. If I also schoose category A, then the measure applied for product group 1 and category A. How could I do that?

[Anonymous]

hi @mjmjn2611 

Try using multiple measure and then select the measure based on Product Group and Category

Measure = SWITCH(Product_Group, 1, SWITCH(Category,A, Measure_1,B,Measure_2),2,SWITCH(Category,A, Measure_1,B,Measure_2))

Thanks!