Forum Discussion
How to calculate an amount and average using several input rows
Hello! I'm new to the whole Power Bi scene and I was wondering if somebody could maybe help me. I have the following kind of data: Gender Age Score Male 18-25 10 Female 35-45...
Ashish_Mathur
Super User
Super UserHi,
Create a matrix visual. Drag Gender and Score to rows/columns and write this measure
Respondents = countrows(Data)
In another visual, drag Age to the table/matrix visual and write this measure
Average age = average(Data[age])
Hope this helps.
Hello,
I don't quite understand what the measures are supposed to do and where they are supposed to go since Im pretty new to Power Bi.
Could you maybe eleborate on this?
Greetings!