Power Bi | Measure | % Difference Label Calculation - No Blanks (visual) (Public)

PHOTO EMBED

Thu Dec 02 2021 22:15:33 GMT+0000 (UTC)

Saved by @cnewnham #vba

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)
	)
content_copyCOPY