Distinct count % issue

[Anonymous]

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 the correct percentages but when i put the field to show values as % of row total its not correct

[Anonymous]

@Anonymous 

Could you provide a sample data with your used formula, A sample pbix would be best. There isn't enough information to figure out what is going wrong.

Best regards
Paul Zheng

[amitchandak]

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.