Forum Discussion
Lookup Value inside another lookup
Hi, Anonymous
Thank you for your feedback.
If you want to create a new table, the formula is different.
Please try the below for creating a new table.
New Table =
SUMMARIZE (
'Table',
'Table'[License Plate],
"Qty of shipping co", DISTINCTCOUNT ( 'Table'[Shipping co Name] ),
"Registered to B", IF ( { "B" } IN VALUES ( 'Table'[Shipping co Name] ), "Yes", "No" )
)Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
Hello Jihwan_Kim, thanks for your reply.
It worked great on the report, however I need this formulas to work on the tables, so I can use the information as a filter to create a few charts. I tried using the same formula, but it didn't work
Hi, Anonymous
Thank you for your feedback.
If you want to create a new table, the formula is different.
Please try the below for creating a new table.
New Table =
SUMMARIZE (
'Table',
'Table'[License Plate],
"Qty of shipping co", DISTINCTCOUNT ( 'Table'[Shipping co Name] ),
"Registered to B", IF ( { "B" } IN VALUES ( 'Table'[Shipping co Name] ), "Yes", "No" )
)
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM