Link a measure to a slicer

[geroagostini]

hi everyone! Please i need help!!

 I need to create a card that contains a measure that is opposite related to a slicer.

 For example, if i have a seller name selected on the slicer, i need the card to give me all the sales of the sales force EXCEPT the one selected on the slicer. How can i do that?

[v-xinruzhu-msft · Accepted solution]

Hi @geroagostini 

You can refer to the following example.

The sample table

Create a new table to put the employee to the table

Table 2 = SUMMARIZE('Table',[Employee])

Then put the new column to the slicer

and create a measure to the old table

Sum_Sales = IF(ISFILTERED('Table 2'[Employee]),CALCULATE(SUM('Table'[Sales]),FILTER('Table',[Employee]<>MAX('Table 2'[Employee]))),SUM('Table'[Sales]))

Output

Best Regards!

Yolo Zhu

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