Forum Discussion

v-shrap's avatar
v-shrap
Microsoft Employee
6 years ago

Distinct count is not working as expected

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.

General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

3 Replies

    • v-shrap's avatar
      v-shrap
      Microsoft Employee
      6 years ago

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        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