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.
Dear all,
This is my first ever post on a forum so if I don't respect a rule please forgive me 🙂
MY issues is that I have a listing of supplier (identifiy by a unique code) that work with 4 business unit (let's call them Pole 1/2/3...)
What I'm trying to do is to identify how many supplier is working only with one business unit (pole 1 or 2 or 3) through the card
For my ExCo when they select for example Business Unit "Pole 1" I'd like the cart to change accordingly to number of suppliers that only belongs to them
Sorry if I'm not clear I can send you more details on request !
Thanks and have a good day
Solved! Go to Solution.
Hi @NicoData1,
Can you please share a pbix or some dummy data that keep raw data structure with expected results? It will help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
In addition, you can also take a look at the following measure formula if helps:
DC_PCount =
VAR dcSupplier =
SELECTCOLUMNS (
FILTER (
SUMMARIZE (
ALL ( Table ),
Table[SupplierCode],
"PoleCount", COUNTROWS ( VALUES ( Table[SupplierCode] ) )
),
[PoleCount] = 1
),
"SupplierCode", [SupplierCode]
)
VAR currList =
CALCULATETABLE ( VALUES ( Table[SupplierCode] ), ALLSELECTED ( Table ) )
RETURN
COUNTROWS ( INTERSECT ( currList, dcSupplier ) )
Regards,
Xiaoxin Sheng
Hi @NicoData1,
Can you please share a pbix or some dummy data that keep raw data structure with expected results? It will help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
In addition, you can also take a look at the following measure formula if helps:
DC_PCount =
VAR dcSupplier =
SELECTCOLUMNS (
FILTER (
SUMMARIZE (
ALL ( Table ),
Table[SupplierCode],
"PoleCount", COUNTROWS ( VALUES ( Table[SupplierCode] ) )
),
[PoleCount] = 1
),
"SupplierCode", [SupplierCode]
)
VAR currList =
CALCULATETABLE ( VALUES ( Table[SupplierCode] ), ALLSELECTED ( Table ) )
RETURN
COUNTROWS ( INTERSECT ( currList, dcSupplier ) )
Regards,
Xiaoxin Sheng
Is the data all coming from the same table or from multiple tables? Are these tables linked in a data model?
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 |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
20 | |
3 | |
2 | |
2 | |
2 |