IF(HASONEFILTER()) with a filter selection?

Hi olimilo,

>>Basically, it should use the general formula if only the Regular Employees filter is selected, or if all filters are selected (ie: fallback). Is it possible to use HASONEFILTER with an "equals to" value? Like:
You can try to use below measure which used to get the select item from slicer:

Selected Item=IF(HASONEVALUE(Table[Column]),VALUES(Table[Column]),BLANK)

>>I'm trying this, but I'm not getting the correct value. If I have all three values selected, it just gets the formula for the Other and not the general formula.

For your requirement, you can try to use switch function with calculate column:

Calculate column:
Utilization Rate = 
SWITCH(test[Type],
	"Other",
			DIVIDE(
				SUM([Days Worked]) + SUM(test[OOF Days]) + SUM(test[Travelling Days]),
				SUM([Days Worked]) + SUM(test[OOF Days]) + SUM(test[Travelling Days])
			),
	"Subcontractor",
				DIVIDE(
					SUM([Days Worked]) + SUM(test[OOF Days]),
					SUM([Days Worked]) + SUM(test[OOF Days])
				),
				DIVIDE(
					SUM([Days Worked]) + SUM(test[OOF Days]) + SUM(test[Travelling Days]),
					SUM(test[Possible Workdays Per Month])
				)
	)

Measure:
Utilization Rate = 
SWITCH(MAX(test[Type]),
	"Other",
			DIVIDE(
				SUM([Days Worked]) + SUM(test[OOF Days]) + SUM(test[Travelling Days]),
				SUM([Days Worked]) + SUM(test[OOF Days]) + SUM(test[Travelling Days])
			),
	"Subcontractor",
				DIVIDE(
					SUM([Days Worked]) + SUM(test[OOF Days]),
					SUM([Days Worked]) + SUM(test[OOF Days])
				),
				DIVIDE(
					SUM([Days Worked]) + SUM(test[OOF Days]) + SUM(test[Travelling Days]),
					SUM(test[Possible Workdays Per Month])
				)
	)

If above not help, please share some sample data to test.

Regards,

Xiaoxin Sheng