cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ShawnPrice Regular Visitor
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 v-huizhn-msft
Microsoft

Re: Multiple Filtering for a Matrix Table

Hi @ShawnPrice,

Please try the following formula.

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

If this still doesn't resolve your issue, please share your .pbix file for further analysis.

Best Regards,
Angelia

View solution in original post

5 REPLIES 5
Microsoft v-huizhn-msft
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
ShawnPrice Regular Visitor
Regular Visitor

Re: Multiple Filtering for a Matrix Table

Angelia thanks for your reply. I tried this based on your response.

 

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 v-huizhn-msft
Microsoft

Re: Multiple Filtering for a Matrix Table

Hi @ShawnPrice,

Please try the following formula.

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

If this still doesn't resolve your issue, please share your .pbix file for further analysis.

Best Regards,
Angelia

View solution in original post

ShawnPrice Regular Visitor
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 v-huizhn-msft
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

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

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!

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?

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

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!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors