Q&A with average

[codebrane]

I was wondering whether it's possible to ask power bi an average question. This question works:

"all student patient adult greater than 4" (shows all the students who have more than 4 adult patients)

but the average doesn't seem to be possible:

"all student less than patient adult average"

to get the list of students who have less than the average number of adult patients. There isn't an average column, just students and total of various types of patient.

thanks,

Alistair

[v-frfei-msft · Accepted solution]

Hi @codebrane ,

Based on my test using Power bi desktop version : Version: 2.79.5768.721 64-bit (March 2020). I can get the average by Q&A.

Could you please share your sample data to me to have a test if you don't have any Confidential Information. Please upload your files to One Drive for Business and share the link here.

[codebrane]

sorry I can't share the data but thanks for the pointer. I can use it to get to the answer.