Count rows with no value

[Muhlig]

I have a data set which shows on time or late delivery

I have added a coloumn which has 2 values "on-time" and "late"

i have used the grouping function to see the amount of orders which follow each of these variables for every supplier

I calculated the % of on time deliveries, and filtered the coloumn so only the "on-time" % is shown.

the issue is that i want to visualize all the companies with 100% "on time delivery" in one colour and the suppliers that doesnt have 100% "on time delivery in another colour

Unfortunately i have a single supplier who only has "late" deliveries, so they are filtered out of the visual, when i choose "on-time".

Can anybody help me get the supplier with only "late" deliveries to show up on the table as 0% "on time" instead of 100% "late".

[BA_Pete · Accepted solution]

Hi @Muhlig ,

Have you tried adding ' +0 ' to the end of your percentage measure?

E.g:

_sales0 = SUM(table[Sales]) +0

Pete