Forum Discussion

Analitika's avatar
Analitika
Post Prodigy
5 years ago
Solved

Distinctcount ALL

Why not working this measure?   m_CountOfCompanies = CALCULATE(DISTINCTCOUNTNOBLANK(_op[Company]),ALL(_op[Company])) m_CountOfClients = CALCULATE(DISTINCTCOUNTNOBLANK(_op[Clients]),ALL(_op[Client...
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Analitika ,

     

    Based on my test, you just need to modify "ALL(_op[Clients])" to "ALL(_op)".

    m_CountOfCompanies = CALCULATE(DISTINCTCOUNTNOBLANK(_op[Company]),ALL(_op))

m_CountOfClients = CALCULATE(DISTINCTCOUNTNOBLANK(_op[Clients]),ALL(_op))

     

    Best Regards,

    Jay

amitchandak's avatar
amitchandak
Super User
5 years ago

Analitika , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.