Forum Discussion

Applicable88's avatar
Applicable88
Impactful Individual
5 years ago
Solved

Countrows in a summarize argument

Hello, I'm very confused about a grouped table with an aggregated function. I will show whats happening in DaxEditor. My table: Serialnumber Status BF33333 K BF33334 K BF33335 K ...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    5 years ago

    Applicable88 , this should give you 10

     

    SUMX(summarize(Tabelle2,[Status],"_cnt",DISTINCTCOUNT(Tabelle2[Status])),[_cnt])

     

    20, I am not sure, may be

     

    SUMX(summarize(Tabelle2,[Status],"_cnt",COUNT(Tabelle2[Status])),[_cnt])

Applicable88's avatar
Applicable88
Impactful Individual
5 years ago

Hi amitchandak ,

with your function I get 2, which also make sense. 

But my question is, why do I get 20? And how to return 5+5=10?

Since I build the summarize table in the first screenshot, I want to summarize the counts of serialnumbers per row. Which I don't understand why it does not leads to 10 .

amitchandak's avatar
amitchandak
Super User
5 years ago

Applicable88 , this should give you 10

 

SUMX(summarize(Tabelle2,[Status],"_cnt",DISTINCTCOUNT(Tabelle2[Status])),[_cnt])

 

20, I am not sure, may be

 

SUMX(summarize(Tabelle2,[Status],"_cnt",COUNT(Tabelle2[Status])),[_cnt])