Unique Value Based on Filter Criteria

[emilypatella]

I have a column in excel called unique inspection. It gives me a true/false value based on how many times an inspection number is listed in another column. Now this is what I need in Power BI:

I need a true/false formula that adjusts based on what is being filtered...for example, 32 inspections had at least 1 maint violation. But the report only shows 28 inspections because those 28 have a value of "true" in the unique inspection column because maint was the first type of violation listed for those particular inspections. How do I get it to say the correct number of unique inspections when filtered based on a certain type of violation but still give the correct number of unique inspections when no filter is applied?

[Seth_C_Bauer]

@emilypatella Could you provide a sample data set with expected outcome? Might help in determining the appropriate calculation.

[emilypatella · Accepted solution]

After searching a little more, I found out that I just needed to use the Dinstint Count formula. Really easy! Thank you for responding!