Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

How to create total measure base on slicer
06-01-2023
04:18 PM
I need to create a total measure for the report,
this measure like under screenshot,
it need to show: 200486.88 in report.
it will base on slicer choice, dynamic get the total number,
and it always matches with a total of Sum of Sales,
Thank you
Solved! Go to Solution.
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-01-2023
04:49 PM

Hi,
Try these measures
Total = sum(Data[Sales])
Total of selected products = calculate([Total],allselected(Data[product]))
Hope this helps.
Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-01-2023
04:49 PM

Hi,
Try these measures
Total = sum(Data[Sales])
Total of selected products = calculate([Total],allselected(Data[product]))
Hope this helps.
Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources
Recommendations
Subject | Author | Posted | |
---|---|---|---|
10-09-2023 04:38 PM | |||
Anonymous
| 06-03-2024 01:22 AM | ||
01-04-2024 02:27 PM | |||
03-14-2023 04:06 AM | |||
06-20-2024 11:12 AM |
Featured Topics
Top Solution Authors (Last Month)
User | Count |
---|---|
89 | |
82 | |
53 | |
40 | |
35 |