Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
103 | |
101 | |
87 | |
73 | |
67 |
User | Count |
---|---|
116 | |
109 | |
94 | |
79 | |
72 |