Need Help: Remove column subtotals from power bi matrix visual

[Samba777]

Hi Folks,

Below is the matric visual, one column contanits Efforts  and other one is Avergae of sprint numbers.

when i added those two columns into Values section, I am getting below output as per below image.

But i dont want to add subtotals for averageof sprint link(X) one in below image. i need to display Totals only.

Any experts please help me here.

Thanks in advance !!

[Barthel]

Hey @Samba777, 

So you only want to show the measure for the total, i.e. when the sprint is not in scope. You can use the ISINSCOPE function for this. Try someting like this:

Measure =
IF ( NOT ISINSCOPE ( 'Table'[Sprint] ), [AverageofLast5sprint] )

[Samba777 · Accepted solution]

It works Perfectly !! thanks