Filter values, but use data in totals

[Larsc]

Hi

First of all, im a real noob when it comes to BI, so this may seem like a stupid question, and im not even sure what im trying to accomplish is doable.

Im creating a report that shows our staff logged working and sick hours.

This looks like this, and gives the percentage of hours they have been sick

Now, in order to tidy up the report, i want to hide the staff that didn't report any sick hours by using a filter that says sick hours has to be greater than 0

This works as well

However, this also changes the hours logged in totals, thus giving a much higher percentage.

Is it possible somehow, to hide the staff with 0 sick hours, but still let their working hours be part of the total?

I hope it makes sense 🙂

[Idrissshatila]

Hello @Larsc ,

well, if you exclude the sick hours it will still exclude the employees with every value you have for them.

It can't still show their numbers without showing them.

If you want you could replace blank with zero.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin