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

CNENFRNL's avatar
CNENFRNL
Community Champion
5 years ago

Hi, Analitika , pls keep in mind that filters propogate along with relationships, if any, among tables in the data model.

 

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

 

Even if filters on _op[Clients] were removed by ALL(), filters from other matrix on other columns in table _op remain effective; which in turn affect the calculation of DISTINCTCOUNTNOBLANK().