How to hide Grand Total on Matrix Visual for selected column and display for others

[smjzahid]

I have a matrix visual and I want to hide the Grand toal for the % Complete To Date column (see snip) and want to display for others, how do I achieve this, 

[Anonymous · Accepted solution]

Hi @smjzahid ,

You may use this measure to replace [%complete to date] in the visual.

Measure = IF(ISINSCOPE('Table'[deliverable]),[%complete to date],BLANK())

Best Regards,

Jay

[nvprasad]

Hi,

You can use the below Dax to get the required output.

% Complete To Date Check = IF(SELECTEDVALUE('Table'[Deliverable])=BLANK(),BLANK(),[% Complete To Date])

Appreciate the Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad