how to count total conditional measures in a card visual?

[gerbearx]

I'm stuck trying to figure out a DAX measure for a card visual that used to work in a single table model but can't figure it out in a converted star schema model. Context filters aren't being maintained: not sure how to count the number of "No's" as users make filter selections.

Below is a summary of the problem.

[gerbearx]

here's the PBIX file:
fruitSales.pbix

[gerbearx]

happy to upload the PBIX if someone can tell me how

[lbendlin]

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

[gerbearx]

thanks! I uploaded to OneDrive and posted a link to the upload PBIX file as a reply to my post

[lbendlin · Accepted solution]

You may want to spend some more time on refactoring your code and data model.  I cleaned it up a little bit. Check the functionality, should be ok now.

[gerbearx]

thanks for helping me solve the problem and teaching me how to be better!