cancel
Showing results for
Did you mean:
Regular Visitor

## Multiple Filtering for a Matrix Table

I have a filtering question that I'm hoping you guys can help me out with. See the image below. The visual called Total to be Called is unfiltered, the Total Calls by date Called is filtered on the current week. What I'm being asked it to make the 72 show up as 118 even though the matrix table is being filtered by the date. They want to see the over all total to be called and not be filtered out like it is now. Is is possible to turn off the filtereing for one value but keep the rest of the values in a matrix. So what October should show is 118/72/61%, and when the week changes to next week it will still be 118/then how many they work on/then the percent of what they worked on of the 118.

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft

## Re: Multiple Filtering for a Matrix Table

Hi @ShawnPrice,

`count Contract Id = CALCULATE(COUNT('Upcoming Expirations 2017 E'[Contract Id]),ALLSELECTED('Upcoming Expirations 2017 E'[week]))`

Best Regards,
Angelia

5 REPLIES 5
Microsoft

## Re: Multiple Filtering for a Matrix Table

Hi @ShawnPrice,

In your Matrix visual, you want the "Count of Contract Id" column always show 118, the "Date Called Contracts" display the values chang as the date slicer, right? If my understanding is right, you can create a measure using the similar formula.

`count Contract Id=CALCULATE(COUNT(Table[ContractId]),ALL(Table))`

Select the measure to replace the "Count of Contract Id" in column level.

If my understanding is not right, please share more detailsfor further analysis.

Best Regards,
Angelia

Highlighted
Regular Visitor

## Re: Multiple Filtering for a Matrix Table

count Contract Id = CALCULATE(COUNT('Upcoming Expirations 2017 E'[Contract Id]),ALL('Upcoming Expirations 2017 E'))

and what comes up is 5668 instead of the 118 that the person should have in sharepoint for the current week filter.

Microsoft

## Re: Multiple Filtering for a Matrix Table

Hi @ShawnPrice,

`count Contract Id = CALCULATE(COUNT('Upcoming Expirations 2017 E'[Contract Id]),ALLSELECTED('Upcoming Expirations 2017 E'[week]))`

Best Regards,
Angelia

Regular Visitor

## Re: Multiple Filtering for a Matrix Table

I don't have a feild called week, should I try to create one? I'm just using the Date Called field and using the slicer on that to get the This week, dates.

Microsoft

## Re: Multiple Filtering for a Matrix Table

Hi @ShawnPrice,

You can create one week, add it as slicer and check if it works? Do you mind share your .pbix file for further analysis? So that we can post solution which is close to what you want.

Best Regards,
Angelia

Announcements

#### Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

#### Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

#### Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

#### Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!