Create DAX measure

[Anonymous]

I am new to Power Bi , I like to create Measure to count how many cells contains more than 3 from System 1 to system 11 columns. Below is my table 

If its 1 or 2 columns i can create measure with Countrows formula and i can sum it but it morethan few columns , Is there any way to create simple Measure ?.

Please support.

[VahidDM · Accepted solution]

Hi @Anonymous 

Can you unpivot all systems columns in Power Query and then count cells with more than 3?

https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098

Appreciate your Kudos!!

[Anonymous]

Thanks for the help.. i will create new table with old sturcture to do other visuals to plot graphs.. 

[VahidDM]

You Are Welcome.

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

Appreciate your Kudos!!