HaiQuanRegular Visitor3 years agoSolvedDax 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. Show Moretamerj13 years agoHi HaiQuan Please try ResultMeasure = CALCULATE ( DIVIDE ( SUM ( Table1[now] ), SUM ( Table1[max] ) ), Table1[class] IN VALUES ( Table2[class] ) )
tamerj13 years agoHi HaiQuan Please try ResultMeasure = CALCULATE ( DIVIDE ( SUM ( Table1[now] ), SUM ( Table1[max] ) ), Table1[class] IN VALUES ( Table2[class] ) )
tamerj13 years agoHi HaiQuan Please try ResultMeasure = CALCULATE ( DIVIDE ( SUM ( Table1[now] ), SUM ( Table1[max] ) ), Table1[class] IN VALUES ( Table2[class] ) )
tamerj1Community Champion3 years agoHi HaiQuan Please try ResultMeasure = CALCULATE ( DIVIDE ( SUM ( Table1[now] ), SUM ( Table1[max] ) ), Table1[class] IN VALUES ( Table2[class] ) )
Related contentDAX commandDAX command to duplicate rowsGrowth % DAX CommandDynamic Sampling In Dax CommandsTop 10 DAX Commands and Tips Every Power BI Developer Should Know
