topic how to use if 3 criteria in power bi in DAX Commands and Tips

how to use if 3 criteria in power bi

Luckylukeman — Tue, 31 Dec 2024 04:23:22 GMT

I need your help to configure the formula

if balance <= 150000 ; balance *rate * portion

if balance <=250000; (150000*rate*portion)+((balance-150000)*rate*portion)

if balance >250000; ((150000*rate*portion)+((250000-150000)*rate*portion)+(balance-250000)*rate*portion)

for example balance is 350000 it will be got 3rd calculated

for 1st leg interest = 150000*rate * portion

for 2nd leg interest = (150000*rate*portion) +((250000-150000)*rate*portion)

for 3rd leg interest= balance - 250000 *rate * portion

i have try

IF(SELECTEDVALUE('Total Saldo Perhari'[Saldo]<=150000000000000,SELECTEDVALUE('Total Saldo Perhari'[Saldo]*0.95*0.06, IF(SELECTEDVALUE('Total Saldo Perhari'[Saldo]<=250000000000000,(150000000000000*0.95*0.06)+SELECTEDVALUE('Total Saldo Perhari'[Saldo]-150000000000000)*0.85*0.06, IF(SELECTEDVALUE('Total Saldo Perhari'[Saldo]>250000000000000,((150000000000000*0.95*0.06)+(250000000000000-150000000000000)*0.85*0.06+((SELECTEDVALUE('Total Saldo Perhari'[Saldo]-250000000000000)*0.8467*0.06)),0))))))))

but error Operator or expression '( )' is not supported in this context.

Re: how to use if 3 criteria in power bi

Irwan — Tue, 31 Dec 2024 04:56:21 GMT

hello Luckylukeman

i assumed you are trying to make measure, so here i created a simple measure example with if statement.

if i copied your DAX, looks like your close parenthesis are misplaced.

you want to put close parenthesis after a column like this SELECTEDVALUE('column'), not at the end of DAX.

Hope this will help.
Thank you.

Re: how to use if 3 criteria in power bi

Anonymous — Tue, 31 Dec 2024 07:33:41 GMT

Hi Luckylukeman.,

Thanks for the reply from Irwan.

Please modify your DAX as below:

Measure = VAR Balance =MAX('Table (2)'[SaldoTest]) RETURN IF ( Balance <= 150000, Balance * 0.95*0.06, IF ( Balance <= 250000, (150000 * 0.95*0.06) + ((Balance - 150000) * 0.85*0.06), (150000 * 0.95*0.06) + ((250000 - 150000) * 0.85*0.06) + ((Balance - 250000) *0.8467*0.06) ) )

The pbix file is attached, please check for details.

If you have any other question please feel free to contact me.

Best Regards,
Qi
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

Re: how to use if 3 criteria in power bi

Luckylukeman — Wed, 01 Jan 2025 02:42:18 GMT

thanks for your advice

Re: how to use if 3 criteria in power bi

Luckylukeman — Wed, 01 Jan 2025 02:43:17 GMT

it works ,,thanks for assistance