Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Calculating absenteeism % KPI - using simple calculation as Absenteeism / Expected hours. I see the three members of the associated dimensions correctly.
When we do the inverse of this - Showrate - as "1 - (Absenteeism / Expected Hour)" as a percentage. I see ALL members of the associated dimensions - expressing all the unexpected sites as 100%.
The logical joins are making seemingly the correct Inner join on the model - I've added filters to ensure that only values where Absenteeism > 0 appear on the visual. I'm not quite sure else how to phrase "what is going on?"
@timmmmeh I would look again more closely to ensure you're filtering out or returning blank in any instances where absenteeism and expected hour are 0 or blank.
You could consider implementing something like:
Showrate =
IF (
AND ( [Absenteeism] > 0, [Expected Hour] > 0 ),
1 - DIVIDE ( [Absenteeism], [Expected Hour] )
)
This changes my result set to now have 0% for the sites I don't expect - and the correct values for entities I do expect.
Even with DAX Studio tracing queries - I'm still not certain this snowflake is returning the right join conditions.
Thanks for the tip though -I appreciate it.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.