Forum Discussion
Any One Can do This ?
Question: How to Show Only the Total Average in a Power BI Matrix (Not for Each Month)?
I am using a matrix visual in Power BI and want to calculate the average for my data, but I only want to display the total average, not the average for each month. However, the matrix is currently showing the average for all the individual months as well. How can I adjust the matrix to show only the total average?
Hi Jalil239
You should be able to use ISINSCOPE for this.
Lets say you have a measure called "Average Measure".
You can make a new measure that would look something like this:
New Average = IF( ISINSCOPE( Table[Month]),"",[Average Measure])ISINSCOPE will evaluate true when the months are "in scope", and false for the totals. You can read more about ISINSCOPE here and here.
Hi all,thanks for the quick reply, I'll add more.
Hi Jalil239 ,
You can achieve your needs indirectly.
1.Turn off word wrap
2.Move the mouse to the marked position, and a '<-||->' sign will appear. Drag it to hide it.
Best Regards,
Wenbin Zhou
4 Replies
Hi Jalil239
You should be able to use ISINSCOPE for this.
Lets say you have a measure called "Average Measure".
You can make a new measure that would look something like this:
New Average = IF( ISINSCOPE( Table[Month]),"",[Average Measure])ISINSCOPE will evaluate true when the months are "in scope", and false for the totals. You can read more about ISINSCOPE here and here.
Its work but it still showing this red area I dont want to show this one
Jalil239 for that, you can use field formatting option and and change the color of taht field to blue, then end user can't see!
