how to hide the total in matrix for particular column row wise (in Matrix visual)

[UI]

Hi Folks,

I have one matrix visual , where i have hierarchy . i dont want to show total of Assurance (2959.63), without using subtotal.

Can anyone suggest me

Regards,

Pratik.S

[amitchandak]

@UI , You can make it blank

a measure like 

if(max(Table[Value]) = "Assurance" && Not(isinscope(Table[Name])) , blank(), [Measure])

Name is is level below it, it is not in scope means it is subtotal

[UI]

@amitchandak  the measure you assign me its not working, can you provide me another solution on this..

Regards,

Pratik .S

[v-rzhou-msft · Accepted solution]

Hi @UI ,

I have a test by creating a sample. I think you can try this code.

Measure = 
IF(
ISINSCOPE(Employees[StaffName]),
[Employee Target],
IF(ISINSCOPE(Employees[StaffOfficeName]),
[Employee Target],
IF(ISINSCOPE(Employees[StaffUnitName]),
IF(MAX(Employees[StaffUnitName]) = "Assurance",
"",
[Employee Target]), 
IF(ISINSCOPE(Employees[StaffPosition]),
[Employee Target]))))

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[UI]

 @amitchandak this mesaure i have used, can we do any edit here, so that it will work