Forum Discussion
Calculated Row in Matrix
I'm brand new to Power BI and I'm having a hard time figuring this out.
I'm building a financial report, and I'd like to include a calculated row (not a column). The data is expense_type (rows) by month (column). Looks like this...
When I try to use DAX to create a percentage of one of the rows (% commission of ad sales), it puts it as an additional column.
The query I'm building this off of is laid out as `amount`, `type`, `date`.
How do I get the calculated information to appear as a row.
My current formula looks like this.
BrokerageCommission = CALCULATE(SUM('reports financialreport'[Amount])*.2,'reports financialreport'[Transaction Type] = "Ad Revenue")That makes sense.
I've written it into the underlying query in data warehouse as a union select, and it's working fine.
Thanks so much for your help.
7 Replies
Hey,
I guess your formula creates a measure, by default measures are put to the columns in a matrix visual:
If you want the measures used on rows, just mark the matrix visual and turn on the property "Show on rows"
Hope this is what you are looking for
Regards
Tom
Thanks, that's helpful feedback, but not quite what I need.
It's now repeatedly showing it as a subset of all rows. I need it to show only once. The same that a subtotal would work.
Well, if i understand you correctly, you'd like to calculate the total Brokerage for all transaction types combined, and show it as another row of Transaction Type.
For example like this:
Transaction Type, Jan, Feb, Mar, ....
Ad Revenue
Ad Sales
.
.
.
BrokerageCommission
Total
Could you confirm that this is what you need? We can help better if we know precisely what is the end visual you'd like to get.
