Calculated field on dimension table from fact table

Hi michaelccdf ,

I know what you want, but the values of calculated columns do not change with different filters. They are fixed, but measures are not. So, creating Measures is the best option. 

Please check if this could meet your requirements.

1. Create Measures.

AbsentPeriod = SUM(Attendance[IsAbsent])

Absenteeism Level = IF ( [AbsentPeriod] >= 1, "High Absenteeism", "Low Absenteeism" )

2. Put "Absenteeism Level" measure on the visuals you want to filter.

Best Regards,
Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.