Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

DAX to display measure values as per multiple values selected on a slicer

Hello brilliant community,   I need help to figure out how can I display measure values as per slicer selections: Here is my case-   'Category' is the report slicer.  If 'A' & 'B' are selected th...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Anonymous ,

     

    To create a measure as below.

     

    Measure = var _sele = CONCATENATEX(category,category[Category],"&")
return
if(_sele="A&B",[Score of A & B],if(_sele = "A&C",[Score of A & C]))

    Regards,

    Frank

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks for the link Nishantjain . It works if only one value is selected on the slicer,  my requirement is multiple values selection on the slicer. Any suggestions?

     

    Thanks,

    Meena