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!
Try it like this.
SUM ( SDA_ApprovedInvoices[WorkdayApprove] ),
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!
Read the announcement for more information!
We're rolling out new Kudos Given badges. Find out how many Kudos you've given.
Get an overview of the events and great community content from November.
Find out where you can attend!