Make measure filtered by slicer, and ignore X-axis filter (even they are the same column)

[Anonymous]

Hi, Thank you for looking at this issue, really appreciate anyone can help me to solve this issue. 

There is a slicer for examle called "city" which have 6 different cities. At the same time, i have a stacked bar chart which also puts "city" as X axis. 

Will filter and select 3 cities in the slicer. Then would like to get the accordingly 3 cities in this stacked bar chart but want to have one measure - # regions for these 3 cities in total rather than # regions for each city. That means this measure should be filtered by that slicer rather than X axis of the chart.

Please see the example: so ideally, i want slicer to control the chart, and accordingly get 3 cities but hope get # regions = 120 for all these 3 cities rather than like b

TableReport

[dax · Accepted solution]

Hi siyue,

If you want to get total value based on slicer, you could try below measure

Measure =
CALCULATE (
    IF ( ISFILTERED ( TOTAL[Country] ), SUM ( TOTAL[amount] ), 0 ),
    ALLSELECTED ( TOTAL )
)

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi, can you help me with this one? Thank you so much. 

https://community.powerbi.com/t5/Desktop/Count-players-dropping-off-on-that-game/m-p/762801#M367573