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

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's avatar
    Moetazzahran
    Icon for Resolver II rankResolver II
    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!