Forum Discussion

Muhlig's avatar
Muhlig
Regular Visitor
3 years ago
Solved

Count rows with no value

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".

 

  • Hi Muhlig ,

     

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

    E.g:

    _sales0 = SUM(table[Sales]) +0

     

    Pete

1 Reply

  • Hi Muhlig ,

     

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

    E.g:

    _sales0 = SUM(table[Sales]) +0

     

    Pete