Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Hi,
Try these measures
Total = sum(Data[Sales])
Total of selected products = calculate([Total],allselected(Data[product]))
Hope this helps.
Hi,
Try these measures
Total = sum(Data[Sales])
Total of selected products = calculate([Total],allselected(Data[product]))
Hope this helps.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
103 | |
98 | |
98 | |
38 | |
37 |
User | Count |
---|---|
152 | |
120 | |
73 | |
72 | |
63 |