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.   

 

Joe_Barry's avatar
Joe_Barry
Icon for Solution Sage rankSolution Sage
2 years ago

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