Forum Discussion
Aggregate a Calculated Measures
Hello everyone. I have created a measure that does exactly what I need it to do which is show an image based on the number. Availiability KPI* = SUMX(ResourceTimephasedDataSet, ResourceTimephas...
I found my solution, took me 4 days to come up with this but I got it. I also had to do it for each case. I hope this will be able to help someone else in the future.
Availiable KPI Ok = COUNTX( DISTINCT(ResourceTimephasedDataSet[Resource ID]), IF(ResourceTimephasedDataSet[Availability KPI*] > -20 && ResourceTimephasedDataSet[Availability KPI*] <= 20, 1))
You are trying to use description that doesnt exist as a table/column i.e Way Overallocated,Overallocated etc..
This means we need to create 1 measure for each of the description.
Way Overallocated = How many resource that is way overallocated
Overallocated = How many resource that is overallocated
Partially overallocated = How many resource that is partially overallocated
.....
and so on..
Then use these measures in a matrix and put the months in column, and its gonna look like this:
Then turn on "show values as rows"
And then it will look like this
I'm also aware I will need multiple measures, I just can't get it to count each time is see a specific value.