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.
Hello,
I'm trying to build a report overview of a workflow process. An order goes through multiple stages needing to be approved by three different teams, multiple times. For instance Team #1 will need to approve it at two different stages in the workflow. Team #2 will need to approve it at three different stages, and Team #3 only needs to give final approval.
I would like to provide a visualization of not the status they're currently in (I've got a table showing that), but which of the three teams the order is currently waiting on.
So if its in status 1, 3 or 5, it would be attributed to Team #1, if its in status 2 or 4 its attributed to Team #2, and if its in status 6 its attributed to team #3.
I'm thinking I need to build a new table first, but i'm struggling on how to write this in DAX.
Any help would be appreciated!
hi, @Anonymous
What is your data structure? How to determine the current state? (status 1, 3 or 5 /status 2 or 4/ status 6)
From your formula, If you need to add some other attribute column in it, for example: Order ID, etc.
Then create a team like this
Then create the relationship with Summary Table by Stats and "Current Status Count".
If not your case, please share sample pbix file or some data sample and expected output. You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.
Best Regards,
Lin
I've created the table counting each status like this:
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |