Forum Discussion

sudhav's avatar
sudhav
Helper V
3 years ago
Solved

Need help

Hi Team,   I used allexcept, all, all selected but nothing helped me.  TIA
Need Help
  • Dhairya's avatar
    Dhairya
    3 years ago

    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!

johnyip's avatar
johnyip
Solution Sage
3 years ago

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.