Create a new column by comparing a Column values with a Measure Value

[Kamalakar]

Hi Team,

Need your help here

I have a table (name: EmpDetails) with two columns as "EmpID" and "Marks"

EmpID	Marks
100	35
200	45
300	55
400	78
500	25
600	92

Now, I have created a mesuare which returns a value (say the value is 50)

I wanted to create a new column in the table as "Flag" which should compare the Marks available at each EmpID and flag it as "Below avg" or "Above Avg"

EmpID	Marks	Flag
100	35	Below Avg
200	45	Below Avg
300	55	Above Avg
400	78	Above Avg
500	25	Below Avg
600	92	Above Avg

can you please help me on this.

Regards,

Kamal M.

[Kamalakar]

Thanks, mahenkj2

this helps.

[mahenkj2 · Accepted solution]

Hi @Kamalakar ,

If your measure1=50 is already defined then you can use:

Flag = IF(SUM('Table'[Marks])>[Measure1],
"Above avg","Below avg")

Hope it helps.