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
  • 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!