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 Everyone,
I am working on individual statistics report showing production of employees.
I want to have certain employee's production, second bar will be average production by his team, and third bar will be average production by country. I am trying to pull different measures yet I got problem on how to use correct DAX formula.
Here's how production is measured:
mProd=CALCULATE(count(tCase[ID]),USERELATIONSHIP(tCase[FinishDate],Dates[Date]))
tCase table has column [FinishUser] which is related to table tPPL with columns Employee, Team, Country by FinishUser=Employee
Chart I need to use will be combo one (clustered columns and lines). Columns will show production, lines will show average production time per case.
And now:
Once I pick employee I want bars to adjust to him, his team, and country.
Any feedback or help appreciated!
Thanks
Solved! Go to Solution.
Hi Maggie,
You are correct.
I already solved this creating additional table.
So I have tables like this:
T1:
Case ID, finish date, finish user
T2: Country, Team, User
T3: Team, date
T4: Country, date
Rest goes with relationships. and creating columns where I put measure
Hi @zgiersky
I make a test for your case, but i'm not very clear, please see my example below.
assume certain employee is a, his production=2,
average production by his team=total production of employees of the Team A/count of employees of Team A ,
average production by country=total production of employees of the Country sd/count of employees of Country sd
Is my understanding right?
Best Regards
Maggie
Hi Maggie,
You are correct.
I already solved this creating additional table.
So I have tables like this:
T1:
Case ID, finish date, finish user
T2: Country, Team, User
T3: Team, date
T4: Country, date
Rest goes with relationships. and creating columns where I put measure
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |