How to create new column in table or matrix to analyze another column

[zqlcancer]

I am able to create a table based on below sample RAW data in PowerBI and generate a new measure called 'Score'. The logic is to use numbers of "good" minus numbers of 'Bad', then divided by total number of 'Rate' value.

My question now is how to create another column in PowerBI table to analyze this new measure 'Score', e.g. if 'Score' is greater than 0 then SL2, otherwise SL1. I tried to create another measure using if or switch but it did not work. Any suggestion would be much appreciated.

[zqlcancer · Accepted solution]

Thanks. This is werid. By the time I posted this question, I can not create a measue using "if" direclty. I just retried and I can use 'if' now.

[v-jingzhang]

Hi @zqlcancer 

You can create a measure with

SL = IF([Score] > 0, "SL2", "SL1")

This measure categorizes the 'Score' measure based on whether it is greater than 0 or not. Then add it to the same table visual where [Score] is located. Did you try this measure?

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.