Forum Discussion
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[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
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
3 Replies
Analitika , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
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().
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
