Looking for Sum of Distinct Count Of Cities

[jay_patel]

Hi All,

I am trying to calculate Distinct Count with no repetative Values Using DistinctCount Function. And the data looks like:-

Ahmedabad	1
Mehsana	1
Delhi	1
Ahmedabad	1
Surat	1
Mehsana	1
SUM	6

Here, It taking Count of Ahmedabad and Mehsana City 2 times, but I need to calculate once 

Ahmedabad	1
Mehsana	1
Delhi	1
Ahmedabad	0
Surat	1
Mehsana	0
SUM	4

Thanks in Advance!

[v-janeyg-msft · Accepted solution]

Hi, @jay_patel 

You can use distinctcount function to calculate once.

Like this:

Or you can drag the city field and select the 'count distinct' mode.

Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,
Community Support Team _ Janey

[amitchandak]

@jay_patel , Try a measure like

Countx(Summarize(Table, Table[City]), [City])