topic Re: Dynamic text filter in dax in DAX Commands and Tips

Dynamic text filter in dax

yamina — Tue, 04 Jun 2024 13:39:57 GMT

Hello ,

Form this request,

""NPS = CALCULATE([NPS], FILTER(Table_BSC_SST,Table_BSC_SST[supplier<>"SBE"))"""

I want to make the supplier field Dynamic. Depending on the chosen supplier, the NPS would be calculated without this choice.

Thank your

Re: Dynamic text filter in dax

Joe_Barry — Tue, 04 Jun 2024 13:47:56 GMT

Hi yamina

Do you only want to see one supplier result at a time or do you want to have the option to choose multiple?

Option One: Add a supplier filter to the page and have a single select on the slicer, this way only one supplier will be chosen at a time

Option Two: As your measure looks correct, it will automatically filter out this supplier you have chosen.

If you have something else in mind, please provide more detailed info

Joe

Re: Dynamic text filter in dax

yamina — Tue, 04 Jun 2024 13:56:25 GMT

Thank you Barry for your uick feed back, but I always have in my page a filter slicer for the supplier, but in my request I want to replace the supplier name " SBE" by a dynamic choice in my slicer filter.

Re: Dynamic text filter in dax

Moetazzahran — Tue, 04 Jun 2024 21:50:25 GMT

Hello yamina ,

Can you please explain what you mean by making the supplier fied dynamic?

Do you mean making the slicer visual dynamic? If yes, if you don't want to show SBE within your slicer, why now exclude it from your slicer altogether in your filter panel?

Please let me know if I am missing the point.

Thank you.
Best regards,
Zahran

Re: Dynamic text filter in dax

yamina — Wed, 05 Jun 2024 08:10:50 GMT

Hello Moetazzahran

In fact, whatever the supllier I choose I want that the result in the visual excluded the result of the supplier choosen. I want to show the impact of the chosen supplier in the overall result.

Re: Dynamic text filter in dax

Moetazzahran — Wed, 05 Jun 2024 08:29:46 GMT

Hello yamina ,
If I understand your requirement correctly, I believe you should use a selectedvalue() in your measure, this selectedvalue () should have the supplier or whatever column used in your slicer that you want to select in your visual.

Following this logic.
NPS = CALCULATE([NPS],Table_BSC_SST[supplier]<>Selectedvalue(Table_BSC_SST[supplier]))

This will help exclude your selected slicer value from the values shown in your table or matrix.

If this solution helps, please accept it as a solution and your kudos will be much appreciated!

Re: Dynamic text filter in dax

Joe_Barry — Wed, 05 Jun 2024 11:45:08 GMT

Hi yamina

You need to create this measure

IF( HASONEVALUE(Supplier[Name]), VALUES(Supplier[Name]), MIN(Supplier[Name]) )

Then add the measure in the format section > Title > fx > Then add the measure above to "What field should we base this on?"

Joe