Percentage for different columns

[gcrespo]

Hi everyone,

I have the following table ( I have removed the column names for privacy. Let's call them Column 2, 3, and so on):

I'd like to get a percentage in every row (Columns 2, 3, 4, 5 and 6) using as divider the value in MaxTechniques:

Percentage = Value in cell / Value in MaxTechniques

The `problem is I don't know how to define a Measure that will affect every column. Is that possible or should I define different Measures for different columns?

Regards,

Gabriel Crespo

[amitchandak · Accepted solution]

@gcrespo , In this case, you have to create that many measures.

example = divide(sum(Table[COlumn 2]), Sum(Table[Max Technique]) )

If you want one single measure, you need to unpivot the columns
Columns 2, 3, 4, 5 and 6

Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g

[gcrespo]

Hi amitchandak,

I was afraid that was the answer... I could unpivot those columns, however, I wouldn't be able to have the aggregation they are showing right now, so I think it's not the best option for me.

Thank you and regards,

Gabriel Crespo