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!

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

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'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

  • 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