Forum Discussion
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
- AnonymousNot applicable
emilypatella Could you provide a sample data set with expected outcome? Might help in determining the appropriate calculation.
- emilypatellaNew 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!