Distinctcount ALL

[Analitika]

Why not working this measure?

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

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

I have to matrix in first i want to show Client Name | m_CountOfCompanies

in second i want to show Company Name | m_CountOfClients

so it working good only if nothing selected, if i select first company name in other matriz i see all this company clients but under each client column everyon client have 1 but i need to count all each clients companies count

[v-jayw-msft · Accepted solution]

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]

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().

[amitchandak]

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