Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Display card based on slicer from 2 columns?

I have the next data:   Value Quality Type 2 Bad L 1 Normal L 2 Bad L 10 Normal INT 5 Bad INT 3 Normal INT   I want to have a single slicer with values Bad, ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

     

    Create a slicer table then create a measure like below:

    Measure = CALCULATE(SUM('Table'[Value]),FILTER('Table','Table'[Quality] in VALUES(slicer[slicer])||'Table'[Type] in VALUES(slicer[slicer])))

     

     

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

 

Create a slicer table then create a measure like below:

Measure = CALCULATE(SUM('Table'[Value]),FILTER('Table','Table'[Quality] in VALUES(slicer[slicer])||'Table'[Type] in VALUES(slicer[slicer])))

 

 

 

Best Regards,

Jay