Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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___"
Solved! Go to 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
If the user selects more that one store or month what do you want the comment to say?
If you select more than one store or month, also comment on the values according to the filters. Thank you
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
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |