Forum Discussion
How to show specific value
I would appericate it if someone can help me. How do I create a DAX formula to only show specific value. For example, I would like to create a Dax formula to only show branch 19, 22, 27 and ex...
Hi noble10
Please try this measure:
Filtered Branch =
CALCULATE (
FIRSTNONBLANK ( 'Table'[Location Name], "" ),
FILTER ( 'Table', 'Table'[Branch] IN { 19, 22, 27 } )
)
the output will be as below:
Did I answer your question? Mark my post as a solution!
Appreciate your Kudos !!
Hi VahidDM,
Thank you so much for your help! I unfortunately was not able to select the measure as a slicer. Not sure why?
Hi noble10
Try to add a column with this code to your table:
IF you want to have Branch No. in your slicer:
Filtered Branch = if('Table'[Branch] in{19,22,21},'Table'[Branch])
If you want to have a Location Name in your slicer:
Filtered Branch = if('Table'[Branch] in{19,22,21},'Table'[Location Name])
Then add Filtered Branch column to your slicer.
Did I answer your question? Mark my post as a solution!
Appreciate your Kudos !!