New Measure with null fields

[Anonymous]

I work in Safety, health and enviroment team in a company.

For that, i need some results about safety forms.

I've created a column with SWITCH funciton, to categorize form data.

Then, i made anothers measures, to COUNTROWS for each category that i want to know how many forms are.

After that, i put all these measures and the category data in a new bar chart. Unfortunetly, i'm not able to make all these measure data be on the same column, they always let some data in blank.

I'm not trying to make another table because i dont want to lose my relationships between tables that already exists.

Can you guys give me some help?

Bellow, my codes and my chart.

Each category, has: RETAIL_QUANTIDADE = COUNTROWS(FILTER('TB_PIRAMIDE';'TB_PIRAMIDE'[SECTOR_SITE] = "RETAIL"))

And the graph with the data:

[Greg_Deckler]

I think that you need to create a single column in your table that has the value you want to display so that basically you only have your "category" and your "value" as columns in your visual.

Tough to say really, I'm not sure I'm following this.

[Anonymous]

Well, and what about the relationship? I dont know how to do that without losing the relationship. And, in advance, i cannot relation two measures, right?