Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Create report together for columns with equal strings

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

3 Replies

  • olgad's avatar
    olgad
    Resident Rockstar
    3 years ago

    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?

  • olgad's avatar
    olgad
    Resident Rockstar
    3 years ago

    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])

     



  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    3 years ago

    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.