SWITCH formula

[Saffira]

Hi, I have a problem with the switch formula.

I would like to list different margin groups.

I have included a separate table in the query, namely:

I have the following switch formula:

The problem is that the categories are not caught properly. For example, in a table I see someone with a 10% margin still listed with the from 15% and above.
How can I solve this? Thanks in advance!

[Saffira]

Hi @rubayatyasmin,

Thank you for your reply.

I am quite new to Power BI and still have a lot to learn.

How do I check conditions from highest to lowest?

I do see that something goes wrong when I put it in an matrix. It looks like this:

How can I fix this?

Thanks in advance!

[rubayatyasmin]

@Saffira 

By try checking highest to lowest I meant to reverse your switch statements condition. Like write >15% first then <=10-15% then <= 8-10% and so on. 

[rubayatyasmin]

Hi, @Saffira 

try checking the conditions from highest to lowest.