Filtering Part of chart

[zgiersky]

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

[v-juanli-msft]

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

[zgiersky · 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