C0001 How to add SOURCE into LOOKOUTVALUE expression ?

[admin11]

Hi All

i have posted below link one week ago :-

https://community.powerbi.com/t5/Desktop/How-to-use-Lookup-command-to-brand-pro-class-desc-from-sale...

i manage to get reply from @HotChilli , his approach is working fine.

Above work fine is because i only load SOURCE=TP sales table.

In my actual doc , i have total 5 different  SOUREC , each source represet one country.

Now my question is for below working expression :-

_Pro Class Decs hotchilli =

LOOKUPVALUE(

'SALES'[pro_class_desc],

'SALES'[pro_class], 'INVC'[pro_class]

)

How to add SOURCE field into it ? So that it will be working .

https://www.dropbox.com/s/uxjgvs5c0k1prq9/PBT_V2021_338%20bring%20pro%20class%20desc%20to%20invc%20w...

MY pbi FILE :-

Paul Yeo

[v-jayw-msft]

Hi @admin11 ,

Has the problem be solved?

If you still need help, can you please tell us what you mean "add source"? Is that mean searching value by another table?

Best Regards,

Jay

[admin11]

@v-jayw-msft 

@HotChilli 

@sanalytics 

Thank you very much for want to help me.

Below image shown it working fine :-

https://www.dropbox.com/s/5mf506pwm4jhbxg/PBT_V2021_353%20bring%20pro%20class%20desc%20to%20invc%20w...

Above link is the PBI file which is working fine.

Below image shown PBIX not working after Add more SOURCE.

https://www.dropbox.com/s/8waairz5aym47o9/PBT_V2021_353%20bring%20pro%20class%20desc%20to%20invc%20N...

Above link is the PBIX file , which is not working , cause by load SOURCE = TS TA TI & TP

Remark :- The different between the working and not working PBIX file , for working PBIX file i load only SOURCE = TP

Paul Yeo

[sanalytics]

Hello @admin11 

Dont understand your requirement clearly..If you want to add Source field then create an another calculated column like you previously did.
And if you want to lookup multiple values then i think you should looking for calculated table rather than column.

Below link can help you

https://www.sqlbi.com/articles/lookup-multiple-values-in-dax/#:~:text=Conclusion,columns%20of%20a%20....

Regards

sanalytics

[admin11]

@sanalytics 

You link very helpful. because that people you tube explanation very clear and well.

Paul