Forum Discussion
Matrix Table Aggregated Values
I have the matrix table below which shows the consumption of each item per year/month. Now for each row on the right side after the last column I want to show the AVG. Is this possible? I do not wan...
Hi TimmK ,
Sorry for my late reply.
According to my understanding, you want to change the default value of Row subtotals,right?
You could use ISINSCOPE() like this:
Measure = IF(ISINSCOPE('Table'[Product]),SUM('Table'[Price]),AVERAGE('Table'[Price]))The final output is shown below:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.