Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Measure based on different columns

Hi everyone, I want to create a percent measure in DAX that is based on 13 columns. The values in these 13 columns are "yes" or "no" answers. So if the person has 7 yes out of the 13, then it nee...
General Comment
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    I'll suggest to first unpivot these columns, so that you get something like this:

    (Select n all the columns containing the "yes" & "no" values > right click > click "Unpivot Columns") 

    Then you can add a new colum to change the "yes" & "no" values to 1 and 0 , to make it easier to do calculations.

     

    Numbers = if(Table[Value] = "yes" , 1, 0)

     

    Now you add a measure that uses this column to calculate the average:

     

    AVG = AVERAGE(Table[Numbers])

     

    Use this measure in a visual to display the % :

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I'll suggest to first unpivot these columns, so that you get something like this:

(Select n all the columns containing the "yes" & "no" values > right click > click "Unpivot Columns") 

Then you can add a new colum to change the "yes" & "no" values to 1 and 0 , to make it easier to do calculations.

 

Numbers = if(Table[Value] = "yes" , 1, 0)

 

Now you add a measure that uses this column to calculate the average:

 

AVG = AVERAGE(Table[Numbers])

 

Use this measure in a visual to display the % :