Reg: Facing issues in comparing two columns

[Anonymous]

Hi everyone,

 I created the measure to comapre two columns. But the measure is always giving the output 1 only.  kindly help me on this issue.

Vlwk Arrowss =

var plans =SELECTEDVALUE(mis[ach(perc)])

var vlwk =SELECTEDVALUE(mis[lwk])

return

SWITCH (

TRUE,

plans > vlwk,1,

plans = vlwk,0,

plans < vlwk,-1

)

Thanks & regards

poornalingam a

[v-yetao1-msft]

Hi @Anonymous 

SELECTEDVALUE :When there is only one value in the specified column, the value is returned, otherwise, the candidate result is returned, and the null value is returned when the candidate result is omitted.

For example :

If you are sure that your data is single, you can use SELECTEDVALUE . Or you can add a single value to the table, and then make a judgment based on this column .

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[gdarakji · Accepted solution]

Try SUM instead of SELECTEDVALUE as SELECTEDVALUE only works when you have a single value. This depends on your data model and the other fields you have in the table but give SUM a try and let us know if it works.

[mahoneypat]

You likely have multiple values in each column in the visual context and both of your SELECTEDVALUE()s are returning BLANK().  Are you confident there are only single values in the visual for each evaluation?  You could try using MIN() instead of SELECTEDVALUE() but will want to make sure there are single values.

Pat