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 everyone,
DIVIDE(COUNT(Table1[X]);sum(Table2[Y))*100
I have this measure which divide a number "X" by a number "Y"and calculate a % of advancement.
But the Number Y has differents values by rows depending on an other column (we'll call it "Z").
For example :
Z Y
a 12
b 11
c 4
On a matrix, it works because i have my Z factor on my row when i create the visualisation.
But i need a graph too with an axe by month and the division is made by the SUM of all my Z Numbers.
To resume : On a matrix i have : count(X) / Sum(Y) (different value by row) --> count(X) / 12
count(X) / 11
count(X) / 4
On a graph i have : count(X) / Sum(Y) --> count(X) / 27
How can i resolve that ?
Sorry if my english is a bit rusty. Hope this is understandable.
Thank you.
Hi @Kitpbi,
From your description, I could not figure out the relationship between ‘Table 1’ and ‘Table 2’ and I could not find the month column you want to create as axis is related to any tables or columns, could you offer me more information or post me your desire picture? To find the cause as soon as possible, I would suggest you share pbix file if possible. If the report does contain sensitive data, please upload your report to your OneDrive and send the link to me via private message.
Regards,
Daniel He
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |