Forum Discussion
Need help
- 3 years ago
Hey sudhav
I have recreated your scenario using sample data
You can modify below measure according to your dataTotal 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 measuresumofrevenue =
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!
Hey sudhav
Can you please share your sample dataset and measure you are plotting.
please write some DAX for that test measure
- Dhairya3 years agoSolution Supplier
Hey sudhav
I have recreated your scenario using sample data
You can modify below measure according to your dataTotal 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 measuresumofrevenue =
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!
- sudhav3 years agoHelper V
Great, thankyou so much. its working