Comparing identical values in columns but detected as different

[SophRow]

Hi,

I am looking at project allocation to make sure my team aren't over or under allocated. To do this I'm comparing values from one column to another in the same table using the following formula:

Allocation = SWITCH(TRUE,('FTE compare'[Project FTE]='FTE compare'[TGI FTE]), "Allocation match", ('FTE compare'[Project FTE]>'FTE compare'[TGI FTE]), "Over allocated", ('FTE compare'[Project FTE]<'FTE compare'[TGI FTE]), "Under allocated")

Whilst it work on most of the rows, some with identical values are coming out as "Over allocated".

See here:

Any help would be greatly appreciated!

Thanks, 

Soph

[truptis · Accepted solution]

@SophRow -> just check if both the columns are of same data type and both of them have same no. Of decimal places and there is no rounding up of numbers.

[SophRow]

Thanks @truptis I converted the data type to text and it worked!

[truptis]

@SophRow , Try using this:

Result= if([Project FTE]==[TGI FTE], "Allocation matched", if([Project FTE] > [TGI FTE], "Over alloted", "under alloted"))

@SophRow -> please mark this as a solution and hit the thumbs up if it helps you. Thank you.

[SophRow]

Thanks @truptis 

I get exactly the same result, i.e. it's still calling two identical values different. I've even been back to the source data and re entered it, and tried a new Power BI file....