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 Guys,
I have some order and production line data. What I want to do is for each production line I want to count the number of occurance of that production line in the table only if there is one order number relating to that production line.
This is the sample data and below is the required answer.
So I want to create a table by Production line number with no of Orders.
Please help.
Link to PBI file
https://drive.google.com/file/d/1syX7jSgZHhEuhDYvBuIqAiLSm52GUR9u/view?usp=sharing
Solved! Go to Solution.
Hi @Anonymous ,
You can use a slicer for the Order.No, create a calculated table:
Table = DISTINCT('Data'[Production Line No.])
A measure to count:
Count =
CALCULATE (
COUNT ( Data[Order No.] ),
FILTER (
ALLSELECTED ( Data ),
'Data'[Production Line No.] IN DISTINCT ( 'Table'[Production Line No.] )
)
) + 0
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
You can use a slicer for the Order.No, create a calculated table:
Table = DISTINCT('Data'[Production Line No.])
A measure to count:
Count =
CALCULATE (
COUNT ( Data[Order No.] ),
FILTER (
ALLSELECTED ( Data ),
'Data'[Production Line No.] IN DISTINCT ( 'Table'[Production Line No.] )
)
) + 0
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous Hi! I can't open the file, Can you paste here the data table on which to calculate what you requested?
Thx,
B.
Order No. | Production Line No. |
Order1 | A |
Order1 | B |
Order1 | C |
Order2 | A |
Order3 | A |
Order4 | C |
Order4 | D |
Order4 | E |
Order5 | A |
Order6 | C |
Order7 | D |
Order8 | E |
Order8 | D |
@Anonymous Here two calculated columns to obtain your result:
@BeaBF Thank you for the response. But we can not do it in a calculated column as the result should dynamically change based on the filters applied.
@BeaBF
here is the Data
Order No.Production Line No.
Order1 | A |
Order1 | B |
Order1 | C |
Order2 | A |
Order3 | A |
Order4 | C |
Order4 | D |
Order4 | E |
Order5 | A |
Order6 | C |
Order7 | D |
Order8 | E |
Order8 | D |
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |