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

     

     

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

richbenmintz 

 

Thanks, it's almost there. I just need to group by the FactTaskExecution_id becaus if batchnumber = 1 in two different FactTaskExecution_id it should count as well if you know what I mean.

 

Thank you.

Rui

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,