Hi, I am just creating a matrix in power bi.
The [Carry Over Revenue FY 17] is a measure that I put into this matrix.
Here is the calculation:
Carry Over Revenue FY 17 = AVERAGE(CRM_Fact_SalesOpportunities[CarryOverRevenueFY17])
When I done this, I always get the average number of this column in Subtotal box automatically. But I wanna get the sum number of this column. How can I fix this?
Go to Solution.
Hi MFelix, @MFelix
Just an information, the red part should be [Average], which is from the blue part.
SUMMARIZE ( Table; Group_Column; "Average"; AVERAGE ( Table[Column] ) );
AVERAGE ( Table [Column] )
You need to do a SUMX of a summarize of your average something like this:
No sure How you have your table set up but chenge the columns by you data.
Proud to be a Datanaut!
Your solution seems very close to what I want.
I used your codes and I found that some values are correct and some are not. Could you tell me what is the 'Table' in your codes? Which 'Table' should I use in this case. By the way, I have two group columns which are located in two tables.
Thanks @MFelix for giving this great idea. It gave me the right direction.
Thanks @v-jiascu-msft for pointing out this a little thing. It works great!!
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!
Check out what's new in the Power BI Community!