topic Re: Measure slicer filter DAX in DAX Commands and Tips

Measure slicer filter DAX

DimaMD — Mon, 04 Oct 2021 20:23:30 GMT

Is it possible to write a measure or a table that would filter the measure
Example matrix

Product	sales	Mesure
a	100	AX
b	80	BX
c	50	CY
d	30	AY

thanks for the help

Re: Measure slicer filter DAX

smpa01 — Mon, 04 Oct 2021 20:04:19 GMT

DimaMD Can you please elaborate it with better data

Re: Measure slicer filter DAX

DimaMD — Mon, 04 Oct 2021 20:21:10 GMT

Ні,smpa01
I have a measure that shows ABC XYZ analysis
The customer wants to filter the value shown by the measure
Is it possible to create a slicer to filter the measure

Re: Measure slicer filter DAX

smpa01 — Mon, 04 Oct 2021 20:31:28 GMT

DimaMD you can not use values from a measure to feed in a slicer. But you can build a disconnected table with input as all the unique values generated by the measure.

Then you can write a measure with SELECTEDVALUE and SWITCH so that the end user can filter the viz with values coming fromthat disconnected table.

https://www.youtube.com/watch?v=AHiCE1N0XHE&t=20s

Re: Measure slicer filter DAX

DimaMD — Tue, 05 Oct 2021 05:56:08 GMT

Ні, smpa01 thanks for the help