Forum Discussion

emilypatella's avatar
emilypatella
New Member
9 years ago
Solved

Unique Value Based on Filter Criteria

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?

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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

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

    • emilypatella's avatar
      emilypatella
      New Member

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