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

PHOTO EMBED

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

Saved by @cnewnham #vba

Measure - Count of Worker - Role - Assigned % difference from Assigned = 
VAR __BASELINE_VALUE =
	CALCULATE(
		COUNTA('94 IndividualProjectCompany'[Worker - Role - Assigned]),
		'94 IndividualProjectCompany'[Worker - Role - Assigned]
			IN { "Assigned" }
	)
VAR __MEASURE_VALUE = COUNTA('94 IndividualProjectCompany'[Worker - Role - Assigned])
RETURN
	1-DIVIDE(__MEASURE_VALUE - __BASELINE_VALUE, __BASELINE_VALUE)
content_copyCOPY