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.
Hi all, have tried to read the board here and get a % of subtotal to work correctly. Below is an image of my Dax formula. I do have filters applied in the filters pane. Is that why my formula does not work? So if I have Filter A = This and Filter B = That and they do not show on the matrix itself, do I have to include that in my formula? It almost seems as if the calculation is being done on all records in the table, not just my filtered records. TIA!
@Razorbx13 , Try a measure like
divide(sum('GL Transaction'[Amount]), calculate(sum('GL Transaction'[Amount]), filter(AllSelected('GL Transaction'), 'GL Transaction'[Account Group] = Max('GL Transaction'[Account Group]))))
Did I miss something?
Check out the November 2025 Fabric update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!