Count values in different columns

[AleksandrMe]

Hi Experts, 

I'm progressing in power BI, but so far did not use any single formula as it just doesn't work for me. If anyone can give me heads up: 

I have one simple data wich looks like that: 

Column 1  Column 2 

Positive      Negative 

Positive     Neutral 

Positive     No Feedback 

Positive 

Negative 

So on, 7 columns. I'm looking into way to create Pie chart to see % of positive, % of negative, % of neutral and so on... 

Any ideas? 

thanks

[Icey · Accepted solution]

Hi @AleksandrMe ,

I suggest you to use "UnPivot" to transform your data. After that everything will be simple. Please refer to this similar post: Count value in different columns.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AleksandrMe]

Thanks for your answer - this helps. I appologize for late reply. 

I have now issue with unpivoting - but I think it's best to create another post for this reason?! 

Kind Regards

Aleks 

[Greg_Deckler]

Seems like you need a multi-column aggregation: https://community.powerbi.com/t5/Quick-Measures-Gallery/Multi-Column-Aggregations-MC-Aggregations/m-...

Either that or unpivot your 7 columns in PQ