Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi all - this should be easy, but I'm struggling...I need to count ALL, in a second column in a table, to then show this as an overall % per row? If you see the screenshot below, I need to understand how to perform a simple count of everything, but keep it on all rows, irrespective of the field ('Referring' in this case)? I need to use this to calculate %, as in the screenshot:
If there's a better way of doing this, would love to hear suggestions! Many thanks indeed.
Kind regards
for Report count all use the below measure,
Report count All =
CALCULATE ( SUM ( 'Test Table Name'[Report Count] ), ALL ( 'Test Table Name' ) )
to find percentage(%) use the below measure,
% =
DIVIDE ( SUM ( 'Test Table Name'[Report Count] ), [Report count All] )
see the attached screenprint for the results,
Thanks,