Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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
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
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.