The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello all,
I would like to ask you for help with following situation:
I have table with data about production orders, which is combination of two tables - Person and Data. After activation of few filters table looks like this:
As you can see on PO 111111111 worked 2 operators - Steve and John. what I want to achieve is that after filtering of the data I will get one row with number of operators worked on specific PO:
For better understanding I am sharing example in pbix file:
Thank you for your help in advance.
P.
Solved! Go to Solution.
Hi,
Try this measure
Measure = if(ISBLANK([Number of operators]),BLANK(),CALCULATE([Number of operators],ALLEXCEPT(Data,Data[PO])))
Hope this helps.
Hi,
Try this measure
Measure = if(ISBLANK([Number of operators]),BLANK(),CALCULATE([Number of operators],ALLEXCEPT(Data,Data[PO])))
Hope this helps.
You are welcome.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
136 | |
106 | |
102 | |
73 | |
59 |
User | Count |
---|---|
266 | |
127 | |
119 | |
100 | |
86 |