cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
timmmmeh
New Member

Unexpected Formula Results...

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?"

2 REPLIES 2
ebeery
Solution Sage
Solution Sage

@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.

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors