Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Problems creating a specific measure

Hello all,   I'm having some difficulties to implment a measure or a workaround to do the following: I need to implement a stacked bar chart to see the "Executed Quantity Batch by Operator". In t...
Need Help
  • richbenmintz's avatar
    richbenmintz
    5 years ago

    Hi Anonymous 

     

    What you need is a Sumx of the Distinct count, forgive the bad measure name

    sumx distinct count = SUMX(VALUES('Table'[FactTaskExecution_id]), [Distinct Batch Count])

    Again pbix sample attached

     

     

     

richbenmintz's avatar
richbenmintz
Resident Rockstar
5 years ago

Hi Anonymous 

 

What you need is a Sumx of the Distinct count, forgive the bad measure name

sumx distinct count = SUMX(VALUES('Table'[FactTaskExecution_id]), [Distinct Batch Count])

Again pbix sample attached

 

 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi richbenmintz 

 

You're legend. Thanks for the solution. I was not getting there for nothing. Need to start thinking when I need 2 measures or something. I'm trying to create always one.

 

Thank you very much.

Have a nice day.

Rui

  • richbenmintz's avatar
    richbenmintz
    Resident Rockstar
    5 years ago

    Hi Anonymous,

     

    You are most welcome, I would imagine you could get the same result using a single measure and storing the intitial distinct count in a variable.

     

    Thanks,