Forum Discussion

zgiersky's avatar
zgiersky
Frequent Visitor
7 years ago
Solved

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

Need Help
  • zgiersky's avatar
    zgiersky
    7 years ago

    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

2 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    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's avatar
      zgiersky
      Frequent Visitor
      7 years ago

      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