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!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
=CALCULATE(
DIVIDE(MAX(Table1[Market Share Numerator]),MAX(Table1[Market Share Denominator])),
ALLEXCEPT(Table1,Table1[NP ID],Table1[Drug]))