Synthax error or did I mess up my dax formula?

[cdawidow]

I created a measure to group my customer price types (cpt) into margin groups after giving them a rank for margin contribution but I keep getting an error message displayed below.  

This is the formula here, It came out perfect, essentially I am just trying to give my Customer Information [cpt] a grouping score based on their gross margin rank.  Any help would be appreciated!

here is my new table i create dfor my margin ranking groups 

[harshnathani]

Hi @cdawidow ,

In the Rank you are comparing an integer value with MIN.

Change MIN and MAX to integers in Power Query.

Regards,

Harsh Nathani

[Pragati11 · Accepted solution]

Hi @cdawidow ,

In your measure you are using comparison operators. Try converting your MIN ans MAX columns to NUMERIC data-type, currently they are TEXT.

Thanks,

Pragati