Forum Discussion
Distinct count % issue
Hi.. Need some assistance while calculating Distinct count i need a % of row total as well which doesnt shows the right % can any one suggests how to calculate it Where as green highlighted are...
If the same numbers repeat the total of distinct count changes. I think you need to do something like so that total adds up
row = sumx(summarize(Table, Table[Month],"_dis" ,distinctcount(Table[ID])),[_dis])
Over GT = sumx(summarize(all(Table), Table[Month],"_dis" ,distinctcount(Table[ID])),[_dis])
Appreciate your Kudos.