How to set a 2 target number related to a slicer

[Preetham909]

I have a slicer which states A & B.

I want the set target to show when I'm selecting a single option, for example if I select the A in slicer the target measure should say 90, 45 for the option B. Now i've simply using the total target of 135 with the simple target measure. Can someone please help me with this? how to split them and with the options and also is it possible to show both combined?

Thanks.

[amitchandak · Accepted solution]

@Preetham909 , Create a target table with two rows

A 90

B 45

Then you can simply use Sum(Target[Value])

or have measure

if(not(isfiltered(Table[Cat])) , 135, if(selectedvalue(Table[Cat]) = "A", 90, 45 ))