nested if condition

[Minal_09]

=If([Sales Channel]='online','[Order ID]',If([Sales Channel]='offline',''))

i am not getting output for this condition please correct the statement if worng.

[ggijben]

Hi Minal_09, 

Are you using the formula as a measure or a dimension?

What is the expected output? The OrderID number? If so, can you try:

=If([Sales Channel]='online',[Order ID],If([Sales Channel]='offline',''))

[Minal_09 · Accepted solution]

Hi 

I am using it as a measure.

Thank You, the solution worked.