Forum Discussion

KMalik's avatar
KMalik
Frequent Visitor
1 year ago
Solved

Ignore filter on Azure map visual

Hi everyone,   I have a slicer for countries on page 1 and it applies to all pages on my dashboard. However, I don't want it applied just on an azure map visual on one of the pages. I have a filled...
Need Help
  • Kedar_Pande's avatar
    Kedar_Pande
    1 year ago

    KMalik 

    Create a new measure that removes the slicer context from the Country filter using ALL in DAX.

    Country_Ignored_Measure = 
    CALCULATE(SUM('YourTable'[YourMetricColumn]), ALL('YourTable'[Country]))

    Replace 'YourTable'[YourMetricColumn] with the actual table and metric you’re plotting on the map.

     

    💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
    Cheers,
    Kedar
    Connect on LinkedIn

Kedar_Pande's avatar
Kedar_Pande
Super User
1 year ago

KMalik 

Create a new measure that removes the slicer context from the Country filter using ALL in DAX.

Country_Ignored_Measure = 
CALCULATE(SUM('YourTable'[YourMetricColumn]), ALL('YourTable'[Country]))

Replace 'YourTable'[YourMetricColumn] with the actual table and metric you’re plotting on the map.

 

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

KMalik's avatar
KMalik
Frequent Visitor
1 year ago

Thanks for your reply.

I have a legend variable which is a text variable as has values like "100-150", "150-200" and so on and I assign colors based on those categories. I am unable to use the measure in the legend field.