cancel
Showing results for
Did you mean:
New Member

## Slicers NOT filtering data on a data card that is using a DAX formula

So i have a series of crossings data that contain various information. Data example is below. Each item belongs to a Tier. I have 3 data cards that will show the number of crossings that belong to a specific Tier. I also have a slicer that can filter the data out by City.

I'm using the following DAX formula to calculate the count of crossings that belong to each tier and use them on each data card.

Count of Tier 1 = CALCULATE(COUNTA('Prioritization Ranking'[DOT #]),FILTER(ALL('Prioritization Ranking'),'Prioritization Ranking'[Tier]="Tier 1"))

The challenge is when i use a slicer (or slicers), it doesn't adjust the numbers in the data cards. What am i doing wrong? HELP!!

 Crossing ID Crossing Name City Tier 1234 Noel Rd Los Alamitos Tier 1 1256 Bloomfield Rd Los Alamitos Tier 1 1289 Katella Ave Long Beach Tier 2 1112 Elm St Anaheim Tier 2 1898 Ball Rd Anaheim Tier 3 8898 Santa Ana Ave Santa Ana Tier 3
1 ACCEPTED SOLUTION
Super User II

Hi @egrospe17 ,

For slicers and filters to affect your measure, you will need to use ALLSELECTED instead of ALL. Try it once.

 Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!Proud To Be a Super User !!!LinkedIn
2 REPLIES 2
Super User II

Hi @egrospe17 ,

For slicers and filters to affect your measure, you will need to use ALLSELECTED instead of ALL. Try it once.

 Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!Proud To Be a Super User !!!LinkedIn
New Member

That worked! Thanks so much!

Announcements

#### Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.