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.
Hello,
i would like to calculate the number of customer based on customer code but exclude those customer name consist of "GOL -". May i know am i missing anything in the measurement?
Solved! Go to Solution.
You can create a DAX measure as follows:
Omni_No. of Customers =
CALCULATE(
DISTINCTCOUNT('Omni Sales Data'[Customer Code]),
FILTER(
ALL('Omni Sales Data'),
LEFT('Omni Sales Data'[Customer Name] , 3) <> "GOL"
)
)
This measure calculates the distinct customer code, excluding customers with "GOL" prefix. Here is the solution screenshot:
As you can see, I have total 6 disticnt customers (ID is unique), but, 4 customers without the "GOL" prefix (as expected). Let me know if this solved your issue.
Best Regards,
Udit
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudo 👍
🚀 Let's Connect: LinkedIn || YouTube || Medium || GitHub
✨ Visit My Linktree: LinkTree
You can create a DAX measure as follows:
Omni_No. of Customers =
CALCULATE(
DISTINCTCOUNT('Omni Sales Data'[Customer Code]),
FILTER(
ALL('Omni Sales Data'),
LEFT('Omni Sales Data'[Customer Name] , 3) <> "GOL"
)
)
This measure calculates the distinct customer code, excluding customers with "GOL" prefix. Here is the solution screenshot:
As you can see, I have total 6 disticnt customers (ID is unique), but, 4 customers without the "GOL" prefix (as expected). Let me know if this solved your issue.
Best Regards,
Udit
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudo 👍
🚀 Let's Connect: LinkedIn || YouTube || Medium || GitHub
✨ Visit My Linktree: LinkTree
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
71 | |
43 | |
21 | |
21 | |
14 |
User | Count |
---|---|
124 | |
42 | |
39 | |
28 | |
24 |