Calculated Field Issue

[gjayne84]

Hi everyone

I have a strange issue with a calculated column that I've setup.  The formula for this column is below:

RiskColour = IF('Table1'[Risk] = "1 - Low",1, IF('Table1'[Risk] = "2 - Medium",2, IF('Table1'[Risk] = "3 - High",3,0)))

This column should return a number between 1 and 3 based on the risk text value.  If the risk doesn't match any of these values (which shouldn't happen as this is a mandatroy field in a SharePoint Online list) then the column should return 0.

However when I add this column to my table visualisation in PBI Desktop I get the following:

Can anyone see any reason why the first record would return 4 for this calculated column?  Every other record is correct but for some reason the top record has returned 4 even though the formula in my calculated column should never return 4?

Any assistance with this would be gratefully received as I can't see why this is happpening.

Thanks in advance.

[Anonymous · Accepted solution]

Click on the right button "don't summarize" in the RiskColour values!

[gjayne84]

@Anonymousperfect, that's working now.  Thank you for such a quick reply!