Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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!
@emilypatella Could you provide a sample data set with expected outcome? Might help in determining the appropriate calculation.
After searching a little more, I found out that I just needed to use the Dinstint Count formula. Really easy! Thank you for responding!
User | Count |
---|---|
94 | |
78 | |
73 | |
64 | |
60 |
User | Count |
---|---|
106 | |
97 | |
76 | |
63 | |
61 |