Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

PBI Distinct Count with multiple rows and column

Hi All, How to create measure to count DISTINCT IDs from multiple criteria from specific row and column? Below are sample dataset and the condition to create measures.   Criteria: How m...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thank you Ahmedx . with this solution we group all the values inside the particular  ID using concatenate. how I'm sure that the particular prevstepid="proc1" flow to stepid="Verify" and prevstepid="Verify" flow to "fail". I'm  seeing from the data there are also captured with this scenario  prevstepid="proc1" flow to stepid="Verify" and prevstepid ="Verify" flow to "Pass".

 

Ahmedx's avatar
Ahmedx
Super User
3 years ago

I didn't understand you, was it the right decision?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    I attached sample screen shot based on the result from the measure created. the count equal to 1 meaning the condition fulfilled while if 0, the condition was not satisfy.

    • Ahmedx's avatar
      Ahmedx
      Super User
      3 years ago

      pls try this

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Thank you.  I'll try this code in actual data.