topic Re: How to use a measure in a slider filter a table in DAX Commands and Tips

How to use a measure in a slider filter a table

PamelaAG — Wed, 02 Feb 2022 09:24:10 GMT

Dear users,

I would like to ask your feedback about how to use a measure into a slider in order to filter a table and some graphs.

I have created a measure called "Index Value" that return the values of 5, 3 and 1, the results are being shown on the table by customer and it is working perfectly.

The problem comes when I tried to used this results in a slicer to filter the table, in order to that, I created table called "INDEX INDICATOR" to which I gave them the following values

Index Color	Index Number
Green	1
Yellow	3
Red	5

Then I created another measure with the following formula

aIndex calculator =

var AAA = [Index Value]

RETURN

(HASONEVALUE('INDEX INDICATOR'[Index Color]),

SWITCH(TRUE(),

VALUES('INDEX INDICATOR'[Index value])=1&&AAA=1,AAA,

VALUES('INDEX INDICATOR'[Index value])=3&&AAA=3,AAA,

VALUES('INDEX INDICATOR'[Index value])=5&&AAA=5,AAA),AAA

)

The conexiton doesn't work, everytime I click on any of the values, nothing is being filtered I cannot use at all the slicer.

Do you happen to know another way to do this or tell me what I am doing wrong?

Thank you in advance,

Pamela

Re: How to use a measure in a slider filter a table

amitchandak — Wed, 02 Feb 2022 10:07:18 GMT

PamelaAG , You need something like this with help from you base table having measure

Sumx(filter(values(Table[ID]), [measure] = max('INDEX INDICATOR'[Index Number])),[measure])

Check this, in place between you will have =

Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1387187#M626

Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k

Re: How to use a measure in a slider filter a table

PamelaAG — Wed, 02 Feb 2022 10:29:58 GMT

Hi, thank you for your answer!

You mean I need to insert this formula into this other formula?:

aIndex calculator =

var AAA = [Index Value]

RETURN

(HASONEVALUE('INDEX INDICATOR'[Index Color]),

SWITCH(TRUE(),

VALUES('INDEX INDICATOR'[Index value])=1&&AAA=1,AAA,

VALUES('INDEX INDICATOR'[Index value])=3&&AAA=3,AAA,

VALUES('INDEX INDICATOR'[Index value])=5&&AAA=5,AAA),AAA

)

Re: How to use a measure in a slider filter a table

amitchandak — Wed, 02 Feb 2022 11:50:37 GMT

PamelaAG , Based on what I got, I want to reconsider the approach ,

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Re: How to use a measure in a slider filter a table

v-janeyg-msft — Tue, 08 Feb 2022 07:12:49 GMT

Hi, PamelaAG

You should know that measure only returns a value, of course it won't have a filter effect.

If you want measure to filter table, you need to put it in filter pane.

I created a sample for reference.

Measure = IF([index value] in VALUES(Table2[index number]),1,0)

Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,
Community Support Team _ Janey