switch two columns with two slicers

[Anonymous]

Hi, recently I have a very complicate problem,

here is the data and relative slicers:

when I select values from slicer1, sum the value from cal1,

and when I select values from slicer2, sum the value from cal2,

when I select both slicer1 and slicer2, sum the value from cal1.

so how can I create such a calculation get the result value, do you have any good ideas?

Thank you.

[amitchandak · Accepted solution]

@Anonymous , Isfiltered can help

Measure =

var _1 = calculate(isfiltered(Dim1[Col]), allselected())

var _2 = calculate(isfiltered(Dim2[Col]), allselected())

return

Switch(True(),

_1 && _2 , [Cal1] ,//assume cal1 and cal2 are measures

_1 , [Cal1] ,

_2 , [Cal2]

)