Create report together for columns with equal strings

[Syndicate_Admin]

Hi, I hope you can help me.
I have in my project, several columns whose data only contain the same type of string: always, almost always, rarely, never. I want to create a donut or pie chart that combines and I see the number of times they appear in all columns for a single column I get like this.

And when I drag the other columns it comes out like this

I wonder if there is any way I can combine the results of all the columns so that instead of for example dividing me into 7 and 7 those of "always", I get 14

[Ashish_Mathur]

Hi,

Not sure of what you want or what your data looks like but i think you should use the "Unpivot Other Columns" feature in the Query Editor.

[olgad]

Suppose you have a table like that named Table

You shall create a table with statuses named Status

Create a relationship to Column1 and then inactive relationship to Column 2

Measure = Calculate(Count('Table'[Column2]), USERELATIONSHIP('status'[Column1], 'Table'[Column2]))+Count('Table'[Column1])

[olgad]

are those statuses a separate field in another table? what is the relationship? could you please just show a few lines of your data? it look like you take column 1 with those statuses , do the count and then put the count of column 2..How many columns in total you have, 2?