Need help - if statement in Dax is not giving desired result

[Anonymous]

Hello All,

I have sales rep column, and their total sales. i am showing the results in the below matrix

so the actual value that i am trying to show from the calculated column as below.

FinalActual = if('Sales Target'[SalesRep] = "ABC",'Sales Target'[totalABC],'Sales Target'[totalseats]-'Sales Target'[totalseatspq] )

so I am trying to show the actual value based on the sales rep name. if the sales rep name is "ABC", then it should show the value of the measure which i created seperately. for others it should be Sales Target'[totalseats]-'Sales Target'[totalseatspq]. But the issue here is, for ABC its not taking the value from the "true condition(Sales Target'[totalABC])" of if statement. its still picking the value of the false condition(Sales Target'[totalseats]-'Sales Target'[totalseatspq]). Please help if i am missing anything here.

Your help is highly appreciated

[jaipal]

hi,@Anonymous , if Sales Target[totalABC is a measure, try and make this as column and see  how it goes

[Anonymous]

@jaipal i tried that. but that also didnt work. when i use that measure seperately in the visual, its showing the correct answer. but with the if statement its not giving me right

[v-janeyg-msft]

Hi, @Anonymous 

The problem is not with the if statement, but with the measure inside you. I don't know which ones you use are measures and which are calculated columns, in short, the two can't be mixed. And you only put a matrix screenshot, we don't even know what the data is like, and your complete formula, how can we help you?

If you still need help, please provide a data sample and your complete needs and results, otherwise we can't get involved at all. 

Janey