Need help calculating % of Status Duration per Agent (each agent should total 100%) when multiple ag

[manoj_0911]

Hi Community,

I’m trying to calculate % of Status Duration per Agent in Power BI.

I have a table visual with the following columns:

• Date

• Supervisor

• Agent Name

• Primary Status

• Secondary Status

• Status Duration (Seconds)

• % of Status Duration (Expected Output)

My goal is:
✅ When I select multiple agents in filters, the percentage for each agent should total 100% independently, not combined.

---

🔹 Example

If I filter two agents — Agent 4 DEV and Agent 4 QA:

Date Supervisor Agent Secondary Status Status Duration (s) Expected %

2025-09-15	Cristina	Agent 4 DEV	Available	47,640	87.02%
2025-09-15	Cristina	Agent 4 DEV	Spec Proj	6,799	12.98%
2025-09-15	Cristina	Agent 4 QA	Available	246	79.87%
2025-09-15	Cristina	Agent 4 QA	Spec Proj	62	20.13%

Each agent should sum to 100% individually, even when multiple are visible.

---

🔹 Data Model Info

🔹 Filters in the report

Date, Division, Group, Work Team, Manager, Supervisor, Agent, Employee ID, Primary Status, Secondary Status.

---

❓ Question

How can I calculate

% of Status Duration = Status Duration / Total Duration (per agent)
so that each agent’s statuses sum to 100% independently, even when multiple agents are visible or filtered?

[parry2k]

@manoj_0911 Well, years of experience working with DAX. Not sure what else to tell - people don't pay attention to modelling and basics of DAX (row and filter context), once you have a handle on that, then it is a matter of time and you will get the hang of it.

ChatGPT - I haven't tried, and not sure how it will work until it knows the full context, when I say context, meaning understanding the model and how data is getting visualized. There are many moving components. That's why when I provide a solution, I don't jump on it until I have the full picture. On the surface, this all looks easy, and a lot of people jump on the solution. As my first reply to your post was, please share a sample PBIX, although I could have provided you with the solution by reading your post, but not without knowing the full details.

Sorry for the long reply, just sharing the process and building blocks to solve the issue. 🙂

[manoj_0911]

Thanks a lot!

[parry2k]

@manoj_0911 sure, basically for the denominator with allselected  function, we are getting the sum of total hours of all selected, and then we are applying the agent filter back using the values function so that we get total hours of the agent in the context. I hope it is clear. Let me know if you need further clarification.

[manoj_0911]

Thank you so much where do you learn these, i was digging deep in chatgpt for hours but the solution it gave didnt work.

[parry2k · Accepted solution]

@manoj_0911 assuming the output I shown is what you are looking for, use following DAX measures: please change name as per your needs:

//create a base measure total duration
Sum Total Duration (Parv) = 
SUM ( AG2_STATUS_SUBHOUR_V[TOTAL DURATION] )

//% measure for each agent

% of Status Duration (Parv) = 
DIVIDE ( 
    [Sum Total Duration (Parv)],
    CALCULATE ( 
            [Sum Total Duration (Parv)],
            ALLSELECTED (),
            VALUES ( PERSONS_V[AGENT] )
    )
)

[manoj_0911]

how to explain this technically

[Ahmedx]

pls try

[parry2k]

@manoj_0911 is this the output you are looking for, given the current selection of two agents:

[manoj_0911]

yes , how you did this , please share 

[parry2k]

@manoj_0911 It will be easier if you share pbix file using one drive/google drive with the expected output. Remove any sensitive information before sharing.