Forum Discussion

yamina's avatar
yamina
Icon for Helper I rankHelper I
2 years ago
Solved

Dynamic text filter in dax

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 NP...
  • Moetazzahran's avatar
    Moetazzahran
    2 years ago

    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!

yamina's avatar
yamina
Icon for Helper I rankHelper I
2 years ago

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.   

 

Moetazzahran's avatar
Moetazzahran
Icon for Resolver II rankResolver II
2 years ago

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