Condition if in table power pivot problem

[nanutum]

i used Power pivot and want to add condition if in table then relationship table have problem


Problem in RED ZONE

when i used condition if table have problem

sorry about my english

[MFelix]

Hi @nanutum,

The question is that in power pivot the blanks is not equal to 0 you need to do something like this

if (
     [%ACH] = "",
     0,
        if ([%ACH] >= "1,
            5000,
            0
            )
  )

Regards,

MFelix

[nanutum]

hi @MFelix

My Problem is 4,5,6 in "B" when i used condition if 4,5,6 show in "A" Why ?

[MFelix]

Hi @nanutum,

Can you post a sample of your data and the final result you want to achieve?

Regards,

MFelix