Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

conditional count

Hello everybody, I have a table that brings information from CRM about workshops the users do. In reality, these workshops can't be more than two per day. And if there is more, it is a mistake. I ...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

is the filter of the workshop not working. Are you able to use distinctcount ?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I thought about using distinct count, but i need to find equals (same date and qualified as a workshop). 

    • amitchandak's avatar
      amitchandak
      Super User
      6 years ago

      Can you share some sample data and expected output

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        I attach a sheet with the information that power BI takes from CRM.

        The rows painted in yellow should count as two. but, the orange ones, should count as one. Because is >2

        That's why I can't just use DISTINCTCOUNT. 

         

        am I making it clear? 

        Thanks for your response.