topic Re: show all the metrics except the measure that had been selected in DAX Commands and Tips

show all the metrics except the measure that had been selected

perezco — Wed, 05 Aug 2020 03:52:30 GMT

Exist a way to show all the metrics except the measure that had been selected from slicer measure list.

this allow me capture the Value selected in the

User Selection Compare = SELECTEDVALUE('_Measure Selector Compare'[Metric])

This will be visible either from table Viz or Matrix Viz.

note: unpivot method is not an option

Re: show all the metrics except the measure that had been selected

amitchandak — Wed, 05 Aug 2020 04:37:49 GMT

perezco , how select a measure, is in this example -https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern

but you have to create a measure that should return blank if it selected in the slicer . This you have to so for all measures.

Re: show all the metrics except the measure that had been selected

perezco — Wed, 05 Aug 2020 15:28:27 GMT

Thanks amitchandak

In this moment I have already a measure slicer where the user can dynamic change the measure.

Do you mean a second messure list ?
From you, Is possible to provide more details by using the sample from the article that you are refering?

In this moment (maybe the hour) I don't visualise how to do it ...let me try later .

Regards,

Cristina

Re: show all the metrics except the measure that had been selected

perezco — Wed, 12 Aug 2020 21:40:46 GMT

amitchandak

I do not get the blank measure in the second measure slicer

Re: show all the metrics except the measure that had been selected

perezco — Sat, 26 Sep 2020 02:25:02 GMT

amitchandak, it will be great if you can provide more details when you mention "create a measure that should return blank if it selected in the slicer . This you have to so for all measures."

thanks