Distinct count is not working as expected

[v-shrap]

I have table that has traffic data for  websites which consist of pageview counts , click events and also visitor ID's. The data is present in Kusto(Azure data exlorer) and i have aggregated these columns by grouping them with some x columns like sum(Pageviews), Sum(clickevents), distinct count(VisitorsID) byx columns and imported data into power bi.

While using these metrics with some dimension column in one visual sum aggregates are working fine where as distinct count is again aggregating as sum. How do i use that column with out any aggregation.

[jdbuchanan71]

In the visual set that field to 'Don't summarize'

[v-shrap]

I do not get an option to not summarize. While i already did- don't summarize to the column alone in column tools.

[v-yiruan-msft]

Hi @v-shrap ,

Could you please give us some sample data and the results you want in order to find the cause of the problem faster and get a solution? Current problem is the visual can't display the correct distinct count of visitors?

Best Regards

Rena