Add New Measure based on Column in Matrix visualization

Question

I have a matrix visualization that I created in PowerBI that looks like this. What I want to do is add a row (like the Total Row) that shows the average Hours/Pilot for the month subtotaled by the Equipment type. The number is a summation for each individual, so when I tried to add an average, it wanted to average the underlying data for the summation. Any ideas?

v-jiascu-msft · Accepted Answer

Hi&nbsp;JKG,
&nbsp;
I created a similar demo. Please download it from the attachment.&nbsp;
The problem here is we can't add a row. But we can get the result in the Total row. Please refer to the snapshot below.
totalIsEverage&nbsp;=
IF&nbsp;(
&nbsp;&nbsp;&nbsp;&nbsp;HASONEVALUE&nbsp;(&nbsp;DimProduct[ColorName]&nbsp;),
&nbsp;&nbsp;&nbsp;&nbsp;SUM&nbsp;(&nbsp;Sales[SalesQuantity]&nbsp;),
&nbsp;&nbsp;&nbsp;&nbsp;AVERAGEX&nbsp;(
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SUMMARIZE&nbsp;(
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Sales,
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'Calendar'[Datekey].[Year],
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'Calendar'[Datekey].[Month],
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DimProduct[BrandName],
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DimProduct[ColorName],
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"totalSales",&nbsp;SUM&nbsp;(&nbsp;Sales[SalesQuantity]&nbsp;)
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;),
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[totalSales]
&nbsp;&nbsp;&nbsp;&nbsp;)
)

&nbsp;
Best Regards,

Forum Discussion

Add New Measure based on Column in Matrix visualization

2 Replies

Related content

Measure two columns

Adding a Static column to a matrix visual of measures

Using a Measure as a Legend in a Stacked Column Visual

Add measure to matrix visual Column

Measure or Calculated Column