Filter results from a Slicer that calls a mesure

[ffarah]

I seem unable to filter the data that is derived from my Slicer which uses the SWITCH command to call a measure. The results of the data are correct except that I cannot filter the information. The measure when used directly works fine, but not when called from a slicer.

the Slicer DAX is as follows:

=switch (TRUE,
Min( Analysis1[ID] ) = 1,
FORMAT([Cascade_Value_All],"$#,#0"))

NOTE. The measure [Cascade_Value_All] works fine on its own and I have no problem filtering, but when I run the measure through the Slicer it brings in unwanted data

Appreciate your help.

Thanks
Frank

 

[Matt Allington]

I have provided a solution that seems to work for you here PowerPivot Forum • View topic - Filter results from a Slicer that calls a mesure