Update DAX to Show (BLANK) as 0% with VAR

[Natasha93]

Hi there 🙂

I have a measurment to show percentage of employees working in office and working from home, but when someone shows as 100% as one, the other measure shows as (blank) In turn, the scatter graph I have doesn't show any data.

What could I add to my DAX to show (blank) as 0%?

I have tried IF, but I think the VAR is throwing it off.

My DAX:

My graphs / cards:

[Idrissshatila]

Hello,

Try adding before the return this:

var result = Divide(WFH_count, Total_count)

Return

SWITCH ( TRUE (), result = BLANK (), 0, result )

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

Follow me on Linkedin

[selimovd · Accepted solution]

Hey @Natasha93 ,

you can just add "+0" and it will always show a zero when the value is blank.

So at the end:

..
RETURN
DIVIDE(...) + 0

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic