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!

5 Replies

  • Dhairya's avatar
    Dhairya
    Solution Supplier
    3 years ago

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

    • sudhav's avatar
      sudhav
      Helper V
      3 years ago

       

      please write some DAX for that test measure

      • Dhairya's avatar
        Dhairya
        Solution Supplier
        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.