Forum Discussion
Solved
How to Count Rows based from a specific value in Multiple Columns in Power BI Measure
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!
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.
2 Replies
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.
Thank you Ashish_Mathur , all good now 🙂
