Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

A DAX question

Dear all, I have a DAX question -    I have a table that has relations between projects and employees -  Project Employee 1 1 2 1 2 2 2 3 3 1 3 2   Now I am lookin...
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    Hi Anonymous 

    You can try this, create the measures below,

    EpCountPerProject = CALCULATE(DISTINCTCOUNT('Table'[Employee]),ALLEXCEPT('Table','Table'[Project]))
    Measure = CALCULATE(DISTINCTCOUNT('Table'[Project]),FILTER(ALL('Table'),'Table'[Employee]=MIN('Table'[Employee])&& [EpCountPerProject]>1))

    for Employee=3,  Counts of Multi People Project=1,

    result

    In this scenario, you don't need to go seek better data model. 

     

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

v-xiaotang's avatar
v-xiaotang
Community Support
4 years ago

Hi Anonymous 

You can try this, create the measures below,

EpCountPerProject = CALCULATE(DISTINCTCOUNT('Table'[Employee]),ALLEXCEPT('Table','Table'[Project]))
Measure = CALCULATE(DISTINCTCOUNT('Table'[Project]),FILTER(ALL('Table'),'Table'[Employee]=MIN('Table'[Employee])&& [EpCountPerProject]>1))

for Employee=3,  Counts of Multi People Project=1,

result

In this scenario, you don't need to go seek better data model. 

 

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.