Possible hours in a month in matrix not the same for each person

[gbrenne]

I have a issue driving me buggy.  I have already figured out how to create a measure that shows the possible working hours there are in a month using a date table and a holiday list.  I am now trying to create a bullet chart with that number as Target2 and noticed that cPossibleHours is a different value for some people in the company (it should be the same for everyone).  I put it in a matrix to make it easier to see the actual numbers.

cPossibleHours = CALCULATE(COUNT('Date'[Date]),'Date'[IsWorkingDay]=TRUE())*8

Can someone shed any light on where I should look?

[parry2k · Accepted solution]

@gbrenne What is relationship between both the tables? Is it single or both direction?

and also try this

cPossibleHours = CALCULATE(COUNT('Date'[Date]),ALL ( 'Date'[Date]), 'Date'[IsWorkingDay]=TRUE())*8

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[gbrenne]

The relationship is bi-directional - and changing it to single worked.  (Formula didn't make a difference.)

Thank you for the quick response!

[parry2k]

@gbrenne the formula change I suggested in case there is any other filter applied on the date dimension but changing cross filter to single fixed it as transaction table is not filtering date table anymore.

Try to  never have cross filter to both in your model. Cheers!!

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡