The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
User | Count |
---|---|
77 | |
75 | |
36 | |
31 | |
28 |
User | Count |
---|---|
105 | |
97 | |
55 | |
48 | |
48 |