Expression help

[jpjust]

All,

I have a expression as below.

I wanted to bring another field (eg., Userfield = EMEA) to the IF condition. I tried many different ways but it seems to be not working. The expression did not throw any error but I don't get the expected value.

Any help will be appreciated.

Num(
IF((license_type_enabled)='Token-based', IF(Userfield)='EMEA',
Sum({<[License Token Type]={"User*"}>}[License Allocated Tokens]),
Sum({<[License Token Type]={"Professional*"}>}[License Total Tokens]),
))
,'#,##0')

[rwunderlich · Accepted solution]

Your second If is the "then clause" for the first if.  You will get nothing if the first if is false.  I'm guessing instead you are instead trying to do an AND or OR. 

IF((license_type_enabled)='Token-based' AND Userfield='EMEA',

IF((license_type_enabled)='Token-based' OR Userfield='EMEA',

-Rob