HELP: Calculate for multiple filters

[Anonymous]

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: 

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)

Kindly help to solve the Dax Calculation Thank you!

[jdbuchanan71]

Hello @Anonymous 

Try it like this.

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

[Anonymous]

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

[jdbuchanan71]

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?

[Anonymous]

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