Problem with conditional table

[diegolima]

Hi guys, how are you?

I need help, I have a problem and I don't know what to do, I have a conditional table that I make with calcultate column for generate the colors:

I use the bookmarks with filters on buttons to change the table, so I change to the red, green and yellow values (the values are the purpose of my analysis, they are problems that generate for devices that need correction), but I do not wish these values of the total above the column, I saw that these values only generate in the red column, when I change to the green column for example these values are not displayed.

I saw some solutions here on the forum, but they are all for the measure table, I'm using it with the calculated column, I don't know what to do, can someone help me?

Thank you all.

[mahoneypat · Accepted solution]

Looks like that top row is coming from the "blank row" (which is created automatically when you have rows in your fact table that don't have a match in your dimension table).  There are 3 ways to fix it

1. Easiest - on the Filters pane, for Filters on this visual, uncheck the "blank" box on the Vermelmo field

2. Eliminate the rows that don't have a match in your fact table, or make it so all rows are present in your dimension table

3. Write a more advanced measure that will ignore the blank row

If this works for you, please mark it as solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat