Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Hello @jhoyskee
Try it like this.
DefectRate = CALCULATE ( SUM ( SDA_ApprovedInvoices[WorkdayApprove] ), FILTER ( SDA_ApprovedInvoices, SDA_ApprovedInvoices[STATUS] = "Rejected" && SDA_ApprovedInvoices[WorkdayApprove] >= 4 ) )
hi @jdbuchanan71, thank you! but applying your suggestion is still showing the same result (330 instead of 72) 😞
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?
that does not work as well i am looking for a 72 but it is summing up to 135. thanks for the help!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |