Display card based on slicer from 2 columns?

[Anonymous]

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, 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?

[Anonymous · Accepted solution]

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

[mangaus1111]

Hi @Anonymous ,

see my pbi file.

https://1drv.ms/u/s!Aj45jbu0mDVJizSH2WjPI3eHT2BR?e=E4cYBm

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.