Dynamic text filter in dax

[yamina]

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  

[yamina]

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.  

[Moetazzahran · Accepted solution]

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!

[Joe_Barry]

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

[yamina]

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.   

[Joe_Barry]

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

[Moetazzahran]

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