comment on a table according to the filters

[ybatistamayo]

I want to comment on a table according to the filters that are selected.

For example I have a table of sales by store and date.

and I would like something like "Store sales ___ for the month___"

[jdbuchanan71]

@ybatistamayo 

If the user selects more that one store or month what do you want the comment to say?

[ybatistamayo]

If you select more than one store or month, also comment on the values ​​according to the filters. Thank you

[jdbuchanan71 · Accepted solution]

You will have to change the table names to match yours but something like this will work.

Comment = 
VAR _Months = 
    IF ( 
        ISFILTERED ( 'Date'[Month] ),
        CONCATENATEX( VALUES('Date'[Month]) , 'Date'[Month], ", " ),
        "ALL"
    )
VAR _Stores = 
    IF ( 
        ISFILTERED ( Store[Store Name] ),
        CONCATENATEX( VALUES(Store[Store Name]) , Store[Store Name], ", " ),
        "ALL"
    )
RETURN "Store sales " & _Stores & " for the month " & _Months