Forum Discussion
VoskaNova
7 years agoFrequent Visitor
Count on a measure?
Hello, Having the hardest time trying to figure out a solution for this. My customer wants a count of the number of people meeting a metric. I have the data currently in a matrix like: T...
v-yuta-msft
7 years agoCommunity Support
Have you solved your issue by now? If you have, could you please help mark the correct answer to finish the thread? Your contribution will be much appreciated.
Regards,
Jimmy Tao
VoskaNova
7 years agoFrequent Visitor
Still have not found a solution to this. The problem is the data coming in needs to be at a claim level. Goals are shown at examiner level though so many claims per examiner. The measure for if they are meeting the goal has to be a measure then so it can scale up and down over month/quarter/year.
You would then need something like a measure calculating if the measure meets the goal or not but then you need to somehow group this by examiner and sum.
But you can't seem to group by in power bi like this.