The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. 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.