Forum Discussion
beginner
Helper I
Helper IHow to retrieve data with multiple location filters when having region and location in the column?
My dataset is working based on location filter and every page has sync filters. Comment per location work fine however whenever I try the region filter for "North America" it does not retrieve region...
bharath_v
Resolver I
Resolver IHi beginner
You can lookup the comments from other table using LOOKUPVALUE DAX as below:
Comment_Lookup = LOOKUPVALUE(Comments[Comment], Comments[Location], Location[Location])
I got the desired output:
Hope this helps!
If I answered your question then mark my post as "Accept it as the solution" and a kudo would be appreciated.