Matrix Visualization - hiding values in columns

Hi, Anonymous 

Try mesure as below:

Measure Available hours1 = 
IF (
    SELECTEDVALUE ( Table1[Resource Name] ) = "Project",
    SELECTEDVALUE ( Table1[Available Hours] ),  
    BLANK ()
)

Measure Available hours2 = 
IF (
    ISINSCOPE ( Table1[Resource Name] ),
    [Measure Available hours1],
    SUM ( Table1[Available Hours] )   // you can change it as any value you want(sum,total,max..)
)

Then drag these fields into matrix values.

pbix attached

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi , Anonymous 

Of course.This function itself is to create a new measure to replace the original field.

Best Regards,
Community Support Team _ Eason