cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jhoyskee Frequent Visitor
Frequent Visitor

HELP: Calculate for multiple filters

I need to calculate the count of total workdayapprove that is greater or equal to 4, and status is "rejected".

 

When I incorporate the condition to a matrix table and used the visual level filters it is showing the data that I need. See below: 

Capture1.JPG

Capture2.JPG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

But I also need to display it in card visual but it seems that I cannot get it with my formula ( I am getting 330 and not 72 just like the matrix table total)

Capture3.JPG

 

Capture4.JPG

 

Kindly help to solve the Dax Calculation Thank you!

4 REPLIES 4
Super User
Super User

Re: HELP: Calculate for multiple filters

Hello @jhoyskee 

Try it like this.

DefectRate =
CALCULATE (
    SUM ( SDA_ApprovedInvoices[WorkdayApprove] ),
    FILTER (
        SDA_ApprovedInvoices,
        SDA_ApprovedInvoices[STATUS] = "Rejected" &&
        SDA_ApprovedInvoices[WorkdayApprove] >= 4
    )
)
jhoyskee Frequent Visitor
Frequent Visitor

Re: HELP: Calculate for multiple filters

hi @jdbuchanan71, thank you! but applying your suggestion is still showing the same result (330 instead of 72) 😞

Super User
Super User

Re: HELP: Calculate for multiple filters

What if you move your filters, the ones that are working on the matrix, from the matrix visual to the page so they apply to all visuals on the page?

Highlighted
jhoyskee Frequent Visitor
Frequent Visitor

Re: HELP: Calculate for multiple filters

that does not work as well i am looking for a 72 but it is summing up to 135. thanks for the help!

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)