DAX - Remove filters for Latitude/Longitude Related Data

[Anonymous]

Hello I'm trying to display an ESRI map with lat/long data but ignoring a filter from a different table. 

Users will be using the new filter pane to filter all other pages in my report apart from this last page which has the map on it. 

I've tried creating measures and columns using ALL but I'm not quite there! This is my latest attempt at a DAX column for the longitude data but when I replicated this for the latitude data it's just lumped all points into one place:

All Longitude Points =

CALCULATE(

    MAX(GeoData[Long]),

    ALL(Cas)

)

Any DAX pointers would be appreciated!

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

I can reproduce your problem.

To remove report level filter for one certain page but keep it for other pages, i would suggest you two ways as workarounds:

1. add "Page level filters" for all other pages, but don't add this filter for that page.

2. duplicate the table to create a new table  and don't connect this new table with your original table, use the columns from the new table to create the map on the certain page.

Best Regards

Maggie

[Anonymous]

Hi @v-juanli-msft 

Thanks for looking in to this!

The page level filters sounds good, I tested this out but it doesn't seem to remember your selection when you move to a new page - do you know if there's a way of fixing this (like you can if it was an in-page filter)?

If not I think I will go for option 2!

Thanks again 

[v-juanli-msft]

Hi @Anonymous 

If you add page slicer on the "FILTERS" pane on the right, it doesn't support to ducplicate this setting for the page level slicer on other page.

However, if you add a slicer visual draging from the Visualization pane on one page,

then you could ducplicate this slicer onto other pages by copying this slicer visual and pasting it onto other pages and selecting "sync slicers".

See more details below.

Synchronize slicers across report pages

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @v-juanli-msft 

Thanks for your thoughts. I was previously using sync slicers in my report, but really like the filter pane experience as it freed up space on the page! Am hesitant to mix and match using both filter mthods for the sake of consistency / user experience!

It would be awesome if the same syncing functionality could be applied to the new filter pane experience.. I guess there will be further development on this as it's new - but where is the best place to submit feedback?

Many thanks!

[v-juanli-msft]

Hi @Anonymous 

It is generous of you

You could submit your idea here.

Best Regards

Maggie