Measure/DAX IF value is less or bigger than

[Anonymous]

Hi all,

I have two tables (actual and target). The tables contains values like 1 and 0, and what I want is to compare those two tables and calculate something like this:

If actual is 1 and target is 1 = the output shuld be 5

If actual is 1 and target is 0 = the output shuld be 10

If actual is 0 and target is 1 = the output should be 15

if actual is 0 and target is 0 = the output should be 20

Please help!!

[SivaMani · Accepted solution]

@Anonymous,

Try this calculation in a measure,

IF([actual] = 0, IF([Target] = 0, 20,15),IF([Target] = 0,10,5))