Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have below formula counting the selected criteria.
= CALCULATE(
COUNTROWS(visits),
visits[Status] = "completed",
visits[Maint topic] IN {"visit", "online meeting", "webinar", "joint visit"},
visits[Main Target Group (Regarding)] = "Installer/Contractor"
)
Finally, I would add DISTINCTCOUNTNOBLANK to count unique values. - this is the part that troubles me.
= CALCULATE(
COUNTROWS(visits),
visits[Status] = "completed",
visits[Maint topic] IN {"visit", "online meeting", "webinar", "joint visit"},
visits[Main Target Group (Regarding)] = "Installer/Contractor",
DISTINCTCOUNTNOBLANK(visits[Regarding Account])
)
Solved! Go to Solution.
@Anonymous , What are you trying to achieve in the second?
try like
= CALCULATE(
DISTINCTCOUNTNOBLANK(visits[Regarding Account]),
visits[Status] = "completed",
visits[Maint topic] IN {"visit", "online meeting", "webinar", "joint visit"},
visits[Main Target Group (Regarding)] = "Installer/Contractor"
)
@Anonymous , What are you trying to achieve in the second?
try like
= CALCULATE(
DISTINCTCOUNTNOBLANK(visits[Regarding Account]),
visits[Status] = "completed",
visits[Maint topic] IN {"visit", "online meeting", "webinar", "joint visit"},
visits[Main Target Group (Regarding)] = "Installer/Contractor"
)
User | Count |
---|---|
79 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
100 | |
91 | |
83 | |
61 |