Forum Discussion
Map and a Table / or Matrix
I would use that filter check to return blank on any measures you don't want shown. Then filter the page with those measures as not blank.
Thanks for the suggestions! I created a measure with => ISFILTERED => and it works correctly!
FALSE when no locations are selected and TRUE when you click on one!
However as you can see in the picture - there's nothing to select in the Visual level filters and I can't drag it to the Page level filters
ISFILTERED() - is there any filter context explicitly on the field named within. The named field must be an axis, legend, table row (PV table, not PP table), matrix row/column, slicer, and/or slicer. What selection is made does not matter, only that some selection other that "Select All" is made.
ISCROSSFILTERED() - is there any filter context explicitly on the field named within OR is there any filter context on another field which can filter the named field. All conditions above still return true. The following also return true: another field in the same table fits the criteria above; another field in a table that exists on the one side of an active relationship (or anywhere in a chain of such relationships) to the table the named field resides in fits the criteria above; another field in a table on either side of an active bi-directional relationship (or anywhere in a chain of such relationships) meets the criteria above.
Essentially - has some selection been made which may reduce the number of items considered in the named field.
HASONEFILTER() - Meets criteria of ISFILTERED() AND the result of that filter is a single distinct value in context for the named field.
HASONEVALUE() - Any circumstance which causes the named field to have only one distinct value - it could be that that's all there is, or the field is filtered in some way (direct or cross filter) to leave only one distinct value in context.