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

Anonymous's avatar
Anonymous
Not applicable
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