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
Measure new = CALCULATE(count('table'[measure]),all('table'[color]))
output
measure1Green = 26
measure1Blue = 4
measure2Green = 5
measure3Blue = 1
desired output for the denominator
measure1Green = 30 (26 + 4)
measure1Blue = 30 (26 + 4)
measure2Green = 6 (5 + 1)
measure3Blue = 6 (5 + 1)
if i can get the denominator calculated then i can finish my percentage of num / den
i saw in Tooltip it does a FIRST and maybe i could use FIRST in my calculate with FIRSTnonBlank(measure,true())
