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.
Hi,
Anyone can help me on this?
I am trying to assigned the sourcing type for the BUPart Concat based on the distinct count of Parent Supplier Name Cleaned.
I have this calculated column however it doesn't give me correct result.
Here's the link to the pbi file:
https://drive.google.com/file/d/1PBqyg_QJTmpoDWXqmMpVxR8T6RJywVlk/view?usp=sharing
The goal is when I visualize that in a chart it will show as multi-sourced only as a whole, considering on the selected multiple months that BUPart Concat have two distinct Parent Supplier Name
everything is in order, the same result should be at the level of the month
you can remove the month if you want:
Sourcing Type =
VAR ParentSupplierCount =
CALCULATE(
DISTINCTCOUNT(Sheet1[Parent Supplier Name (Cleaned)]),
ALLEXCEPT(Sheet1,Sheet1[BUPart Concat],Sheet1[Is Inter-Company Supplier])
)
RETURN
IF(
ParentSupplierCount > 1,
"Multi-sourced",
"Single-sourced"
)
What if regardless of the month, the result should be multi-sourced? How can I do that?
I wrote to you above, you should write like this
ALLEXCEPT(Sheet1,Sheet1[BUPart Concat],Sheet1[Is Inter-Company Supplier])
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
80 | |
60 | |
59 | |
58 |
User | Count |
---|---|
157 | |
119 | |
104 | |
77 | |
69 |