Vlookup from a measure result in matrix

[diazjp]

i have a dashboard from excel like this

"Total SKU XML" field is vlookup from "Total SKU" field

but my dashboard is like this, i dont know how to vlookup from measure's result in the visual

Total SKU in AreaPricing is

= CALCULATE( DISTINCTCOUNT(CSDPVSXML[ProductId]),ALLEXCEPT('DT Active','DT Active'[Status]), NOT( ISBLANK(CSDPVSXML[ProductId])))

Total SKU in other table

= CALCULATE( DISTINCTCOUNT(CSDPVSXML[ProductId]), NOT( ISBLANK(CSDPVSXML[ProductId])))

Total SKU XML

= CALCULATE( DISTINCTCOUNT(CSDPVSXML[ProductId]), NOT( ISBLANK(CSDPVSXML[ProductId])), REMOVEFILTERS('DT Active'[Status]))

is there a way so the filter context for "Total SKU XML" is based on Area Pricing so it will show 18 like Area Pricing table ?

Thank you in advance.

[amitchandak]

@diazjp , we have lookupvalue,

But It might need an approach to revisit based on what you need

https://learn.microsoft.com/en-us/dax/lookupvalue-function-dax

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[diazjp]

is there a way to use row filter of AreaofPricing instead of sales level fromat 3 ?
the lookup function only lookup into table, not the result of a measure

do i need to paste the data in here or is there another way to show the sample data ?