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.
table
1-measures
2-colors
3-months
the request is a bar for every measure + color as a percentage of (measure color / measure all colors)
so i made a new measure of "measure + color" and that works for a count and seperate bars over time.
NOTE: each monthly group of bars can have several different measures + colors
i need to do a calculation so that it can extract that measure and get a count of all colors of that measure for the denominator. the numerator is already the count i have working.
just trying to get the denominator i want all colors for that measure but this calculation just gives me counts for measure + color
Hi @Anonymous ,
Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
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 |
---|---|
106 | |
94 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |