Need help

[sudhav]

Hi Team,

I used allexcept, all, all selected but nothing helped me. 

TIA

[johnyip]

@sudhav If I understand correctly and if you want the country slicer to apply filtering only on the card visual but not the remaining slicers, you should probably using the Edit interaction function that you do not prefer using to disable the interactions between different slicers.

Alternatively, as per your requirement, you may construct four additional STANDALONE calculated tables (i.e. no relationships between any other tables), and then use them in your slicers and DAX.

[Dhairya]

Hey @sudhav 
Can you please share your sample dataset and measure you are plotting.

[sudhav]

please write some DAX for that test measure

[Dhairya · Accepted solution]

Hey @sudhav 
I have recreated your scenario using sample data 
You can modify below measure according to your data

Total Sales = 

CALCULATE(
    SUM(financials[ Sales]),
    ALL(Manufacturer[Segment]), 
    ALL('Product'[Product]), 
    ALL(financials[Date])
)

By using this measure the slicer plotted using Manufacturer[Segment], Product'[Product] and financials[Date] column will not affect the card visual.

In your scenario you using following measure

sumofrevenue = 
CALCULATE(
    SUM(Sales[Revenue]),
    ALL('Sales'[Date]),
    ALL('Manufacturer'[ManufacturerID]),
    ALL('Product'[ProductID])
)

 If this helps you, please kudo this post and accept it as a solution so that others can find it quickly while facing a similar issue. Thank You!

[sudhav]

Great, thankyou so much. its working