Apply slicer only to one value in the visual

[Anonymous]

I want to add a Gauge visualization tile to my report.

My sample of data looks like this:

My Gauge visual has:

• Value = Count of Rows (with 'Score' and 'Quarter' filter)
• Maximum value = Count of Rows (with 'Quarter' filter and without 'Scores')

I want to apply 'Quarter' filter to both 'Value' and 'Maximum Value', but other 'Scores' filter only to 'Value'. Following is expected output

So basically I want to apply some slicer to one value of visualization and another slicer to all values. Is that possible?

[v-jayw-msft · Accepted solution]

Hi @Anonymous ,

You will need a DAX formula to get Maximum value.

Use ALL() function to avoid the filters you don't need.

Measure = CALCULATE(COUNT('Table'[Quarter]),FILTER(ALL('Table'),'Table'[Quarter]=SELECTEDVALUE('Table'[Quarter])))

 

Best Regards,

Jay

[amitchandak]

@Anonymous , do you want max not to use slicer value?

Try a measure like 

maxx(all(Table), Table[Value])

[Anonymous]

1. I am interested only in showing count of rows with selected data (not maximum values of score)
2. Use of ALL would have been helpful, but my problem is a little different than what I originally posted where I had only one slicer.

I have updated my question. Kindly have a look and share any ideas that you get. Thank you