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:

 

ValueQualityType
2BadL
1NormalL
2BadL
10NormalINT
5BadINT
3NormalINT

 

I want to have a single slicer with values Bad, Normal and INT

 

Then a card shall display:

When Bad is selected in the slicer display: 9

When Normal: 14

When INT: 18

 

Is this possible/doable?

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

2 Replies

  • 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