Dax command

[HaiQuan]

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.

[tamerj1 · Accepted solution]

Hi @HaiQuan 
Please try

ResultMeasure =
CALCULATE (
    DIVIDE ( SUM ( Table1[now] ), SUM ( Table1[max] ) ),
    Table1[class] IN VALUES ( Table2[class] )
)

[HaiQuan]

Thank you bro, it works, nb!