Count of Status combined

[Anonymous]

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!

[v-lili6-msft]

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

[Anonymous]

I've created the table counting each status like this: 

Summary Table =

SUMMARIZE (

'Remediation', // Current Table Name

'Remediation'[WorkflowStatusId], //Column of Statuses

"Current Status Count", COUNTROWS ( 'Remediation' ) //Counts the number of occurences of each status

)