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...
wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
5 years ago

you can add a IF function in your measures, such as 

 

IF(SELECTEDVALUE(table[Branch]) IN {19,22,27},[old measure])

  • noble10's avatar
    noble10
    Frequent Visitor
    5 years ago

    Hi wdx223_Daniel  

     

    I tried that and it doesn't seem to work either.  

    I was unable to generate a slicer after creating the measure.