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,

 

Making some assumptions on the Visual requirement, the following measure provides the distinct count of Batches

Distinct Batch Count = DISTINCTCOUNT('Table'[BatchNumber])

Resulting in the following visual

Attached please find a simple sample file

Thanks,

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,