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.
To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
I have two tables, and the PrimaryKey is Class. I need a dax to calculate the sum of now divided by the sum of max when there is a filter Quarter.
Solved! Go to Solution.
Hi @HaiQuan Please try
ResultMeasure = CALCULATE ( DIVIDE ( SUM ( Table1[now] ), SUM ( Table1[max] ) ), Table1[class] IN VALUES ( Table2[class] ) )
View solution in original post
Thank you bro, it works, nb!
Check out the September 2025 Power BI update to learn about new features.
