Forum Discussion

noble10's avatar
noble10
Frequent Visitor
5 years ago

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...
noble10's avatar
noble10
Frequent Visitor
5 years ago

Hi VahidDM, 

 

Thank you so much for your help! I unfortunately was not able to select the measure as a slicer. Not sure why? 

VahidDM's avatar
VahidDM
Icon for Super User rankSuper User
5 years ago

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

 

 

 

 

 

 

  • noble10's avatar
    noble10
    Frequent Visitor
    5 years ago

    Hi VahidDM  

     

    I tried the instruction above but it dosen't seem to work.