Forum Discussion
Helper IDynamic 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 NPS would be calculated without this choice.
Thank your
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!
6 Replies
- Joe_Barry
Solution Sage
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
yaminaThank 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
Resolver II
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
- 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
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!
