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
Announcements
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Recommendations
Subject | Author | Posted | |
---|---|---|---|
10-09-2023 04:38 PM | |||
Anonymous
| 06-03-2024 01:22 AM | ||
01-04-2024 02:27 PM | |||
02-06-2023 04:58 AM | |||
03-14-2023 04:06 AM |
Featured Topics