Forum Discussion
Measure as Slicer
Hello everyone.
I return to this great community with one more doubt.
I have a table similar to this one:
Name Measure A Measure B
aaaa -0.23 0.85
bbbb 0.15 0.93
ccccc 0.25 0.97
Now, I would to add slicer only saying "Details". If we click on it, I wanted it to show only the lines where Measure A was greater than 0 and Measure B was greater than 0.9.
I already created the additional table, but now the measure is not working for me.
Any idea?
Thank you very much,
Simao
Add the calculated column as per below screen shot and add slicer column in "Slicer"
4 Replies
Anonymous , In this can you need bookmarks and a button for details.
You can use visual level filter for [measure A] and [Measure b]
or need have measures like
measure 1 -1 = calculate([Measure1], filter(values(Table[Name]), [Measure1] >.9 ))
measure 2 -1 = calculate([Measure2], filter(values(Table[Name]), [Measure2] >.9 ))
or
measure 1 -1 = calculate([Measure1], filter(values(Table[Name]), [Measure1] >.9 && [Measure2] >.9 ))
measure 2 -1 = calculate([Measure2], filter(values(Table[Name]), [Measure2] >.9 && [Measure1] >.9 ))
Add the calculated column as per below screen shot and add slicer column in "Slicer"
Anonymous
Create this measure and assign it to the visial filter and set it equal to 1
Filter Measure = If( [Measure A] > 0 and [Measure B] > 0.9 , 1 , 0)
