Forum Discussion

HaiQuan's avatar
HaiQuan
Regular Visitor
3 years ago
Solved

Dax command

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.

 

 

Help
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi HaiQuan 
    Please try

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

2 Replies

  • tamerj1's avatar
    tamerj1
    Community Champion
    3 years ago

    Hi HaiQuan 
    Please try

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