How to insert one condition to my exiting expression PnL_YTD ?

[admin11]

Hi All

I have 1 question , hope some one can advise me.

I have this expression working fine :- 

PnL_YTD = SUMX('_PnL_Table','_PnL_Table'[Switch_YTD REV&COGS_])

I like to add below condition E01 PAYROLL to PnL_YTD expression .

E01 PAYROLL =

SWITCH(

TRUE(),

'GL'[GL Code] = 81651

|| 'GL'[GL Code] = 80351

|| 'GL'[GL Code] = 81705

|| 'GL'[GL Code] = 90351

|| 'GL'[GL Code] = 90611

, "YES",

BLANK()

)

it should look some thing like below :-

PnL_YTD_PAY = if(E01 PAYROLL=YES), SUMX('_PnL_Table','_PnL_Table'[Switch_YTD REV&COGS_])E01

But above cannot work.

Paul Yeo

[nvprasad]

Hi admin11,

try appling  E01 PAYROLL=YES filter in sumx like bellow.

SUMX(filter ('_PnL_Table','_PnL_Table'[ E01 PAYROLL] = "Yes"),_PnL_Table'[Switch_YTD REV&COGS_])E01

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad

[admin11]

@nvprasad 

My E01 PAYROLL field is column field ,  store at GL Table , i am unable see that field GL Table . See below image :-

[nvprasad]

Hi,

If function you can use only measure as a logic parameter not column.

Thank You,

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad

[admin11]

@nvprasad 

Thank you for your reply.

May i know any workaround ?

Paul

[Vera_33]

Hi @admin11 

What is the relationship between these two tables?

[admin11]

@Vera_33 

Thank you for look into my post.

i have create a new post with my simple PBI file on below post :-

https://community.powerbi.com/t5/Desktop/How-to-insert-condition-into-my-YTD-EXP-expression/td-p/196...

Hope you can advise me.

Paul