The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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,