Measure - Legal Compliance Rate = VAR Legal_BASELINE_VALUE = CALCULATE( COUNTA('95 Calc - Requirements Table'[IndividualID]), '95 Calc - Requirements Table'[Mixed Tag] IN {"Legal"} ) VAR Legal_MEASURE_VALUE = CALCULATE(COUNTA('95 Calc - Requirements Table'[IndividualID]), '95 Calc - Requirements Table'[Requirements Status (Group + Competency)] = "Compliant", '95 Calc - Requirements Table'[Mixed Tag] IN {"Legal"}) RETURN IF( NOT ISBLANK(Legal_MEASURE_VALUE), DIVIDE(Legal_MEASURE_VALUE, Legal_BASELINE_VALUE) )