How to Count Rows based from a specific value in Multiple Columns in Power BI Measure

[ian11001]

Hello Good day,

I'm currently trying to figure out, how can I count the row based from a specific value in multiple columns, kindly please refer on the image below.

Based on this table, I want to count the number of "Not Applicable" value in multiple columns using measure in Power BI

Thank you in advance!

[ian11001]

Thank you @Ashish_Mathur , all good now 🙂

[Ashish_Mathur · Accepted solution]

Hi,

Your data is not well arranged.  In the Query Editor, select all columns other than the Question columns and right click.  Select "Unpivot Other Columns".

Hope this helps.