Any One Can do This ?

[Jalil239]

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?

[dk_dk · Accepted solution]

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.

[dk_dk · Accepted solution]

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.

[Jalil239]

Its work but it still showing this red area I dont want to show this one 

[v-zhouwen-msft · Accepted solution]

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

[Selva-Salimi]

@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!