Adding sub-text to matrix

[gkc]

Hello everyone! 

I am working on a dashboard and what I ideally want to do is to add a disclaimer when a person is exporting one of the matrix visuals. Something like:

Table look:

Column 1	Column 2
a	1
b	2
c	3

Table look when exported:

Column 1	Column 2
a	1
b	2
c	3
"Sample text"	"It can be anywhere the location doesn't matter"

However, it seems like that is not a future yet. Instead, I was hoping to add a sub-text to the matrix view. Something like a footer or header maybe. Or add a text box and group them so they can only be downloaded together. So far I couldn't figure out a way to do this. Can someone help, please? 

[amitchandak · Accepted solution]

@gkc , if you are not using the total column, then you can have it there

using isfiltered or isinscope

a measure like

if(not(isinscope(Table[Column1])) , "Text",Format( [Measure], "#,###") )

[gkc]

Thank you! I think this is the closest option I have at the moment!