topic I don't want to involve blank cells in my measure in DAX Commands and Tips

I don't want to involve blank cells in my measure

Anonymous — Wed, 30 Nov 2022 16:08:49 GMT

I'm now doing a internship so im a noob with Power BI. the thing is, on the left i have hours and on the right the standard worktime. i want to show if someone goes over the standard worktime it will turn red. but now even if its blank it turns red. im new with dax. what i did was if hours - worktime >= turn green otherwise red:

can someone please help im wiasting too much time.

Re: I don't want to involve blank cells in my measure

Anonymous — Thu, 01 Dec 2022 08:24:05 GMT

Hi Anonymous ，

Try this measure:

Measure = IF(SELECTEDVALUE('Table'[hours])-SELECTEDVALUE('Table'[standard worktime])>=0,"#FF0000","#00FF1E")

And this is my conditional formatting:

You can also refer to my pbix file for better understanding.

Best regards,

Community Support Team Selina zhu

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

Re: I don't want to involve blank cells in my measure

Anonymous — Thu, 01 Dec 2022 08:39:44 GMT

Hi,

Thanks for your answer i really appreciate it, but the thing is i want the blank fields to not be included in the measure. so i want the rows that dont have a working time to be the same as before. if i look at what you did i still see the second row (in your printscreen) turning red while there is no working time. i tried your measure but i get the same result as mine....

Kind regards,

Re: I don't want to involve blank cells in my measure

Anonymous — Fri, 02 Dec 2022 05:50:45 GMT

Hi Anonymous ,

If you don't want the blank row, you can directly filter it out, like this:

Please check the pbix file I uploaded above to make sure it is not different from your process.

Best regards,

Community Support Team Selina zhu

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

Re: I don't want to involve blank cells in my measure

Anonymous — Fri, 02 Dec 2022 07:32:47 GMT

Hi, thanks for your reply i really appreciate it!

the thing is i dont want the blank rows to be involved in the maesure. so if there is a blank standard working time, then i want hours not to be involved to any measure or condition. so it will be the same colour and still shows hours.

so for you to understand i want this:

i hope you understand what i want to do.

thankyou for your reply!!

Re: I don't want to involve blank cells in my measure

Anonymous — Fri, 02 Dec 2022 07:33:49 GMT

Sorry i mean i want it like this