DAX cell lookup

[Anonymous]

I have been tryign to fill in % value in  Baked Goods Gross Margin(31290) by Dividing NetGP & Sales of Budget or Actual. Just like Excel Vlookup method. any  idea.  Please see screen shot below. 

[Whitewater100]

Hi:

Can you share example of your table(s) you are working with(dummy data is  fine).

One thing you most likely want to do is to get the gross margin amount separated from the line of text it is in.

Also are those measures of just descriptions below.

Normally your solution would be based on measures with numerical results.

E.G. GM% = DIVIDE([Baked Goods GM$], [Baked Goods Sales Amt])  Based on your data set up the GM measure could be GM% = DIVIDE([Margin$], [Total Sales])   DIVIDE([Margin$], [Total Budget])  

With a bit more info we can solve this. Thanks