Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
zgiersky
Frequent Visitor

Filtering Part of chart

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

1 ACCEPTED 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

View solution in original post

2 REPLIES 2
v-juanli-msft
Community Support
Community Support

Hi @zgiersky

I make a test for your case, but i'm not very clear, please see my example below.

4.png

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors