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

     

     

     

DemoFour's avatar
DemoFour
Continued Contributor
5 years ago

Hi Anonymous 

 

Can you confirm this data table is right and what it is you want to achive please. 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hello, DemoFour 

 

I want to show in one stack bar chart the Executed Batches By Operator. Looking at the data the expected result should be:

  • 1 distinct for FactTaskExecution_id = 2717
  • 2 disctinct for FactTaskExecution_id = 2774
  • 1 distinct for FactTaskExecution_id = 2787
  • 1 distinct for FactTaskExecution_id = 2802

So the final result should be the sum of the above values which is 5.

 

However using just the distinctcount is not enough because different FactTaskExecution_id can have the same batchnumber and I want the sum of them. Don't know if you understand..

 

Thanks,

Rui