Create dynamic measure which tells a user what field they filtered on, and what items they filtered

[JemmaD]

So I have a table called 'Brokers' and this table has three columns with three heirarchies of Broker name: 
Global Broker Name
Parent Broker Name
Broker Name.

I want a slicer which says if table 'Brokers' is filtered, show the column they filtered on, and the concatenated values they filtered on.

I could do this using three separate measures but I wanted to do it in one measure if possible. 

[amitchandak · Accepted solution]

@JemmaD , You can use isfiltered and check like

example

measure =  "Global Broker Name : " &  if(isfiltered(Table[Global Broker Name]) , Concatenatex(Table, Table[Global Broker Name]), ", ")  & unichar (10) &

"Parent  Broker Name : " &  if(isfiltered(Table[Parent Broker Name]) , Concatenatex(Table, Table[Parent Broker Name]), ", ")  & unichar (10) &

"Broker Name : " &  if(isfiltered(Table[Broker Name]) , Concatenatex(Table, Table[Broker Name]), ", ")  & unichar (10)