Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi guys
I know this has been posted a couple of times, but I cannot get the other guides to work, so i was hoping you would help me.
I have this table:
Customer name | Our # visits | Their # visits | Our % of total visits |
Customer 1 | 10 | 90 | 10 % |
Customer 2 | 20 | 80 | 20 % |
Customer 3 | 15 | 75 | 15 % |
Total | 45 | 245 | 15.52 % |
I need the total of "our % of total visits to be equal to 45 % and not 15.52 %
I tried using the meassure provided by others in this forum
Solved! Go to Solution.
Try a new measure like
sumx(summarize(Table, Table[Customer name],"_our",[ Our % of total visits]),[_our])
USe measure [ Our % of total visits]
Try a new measure like
sumx(summarize(Table, Table[Customer name],"_our",[ Our % of total visits]),[_our])
USe measure [ Our % of total visits]
Thank your very much!
It worked perfectly 😄
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |