cancel
Showing results 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

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
Frequent Visitor

Hi Maggie,

You are correct.

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

2 REPLIES 2
Community Support

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

Frequent Visitor

Hi Maggie,

You are correct.

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