In Power BI I am trying to build a report that is similar to one built in Excel shown in the image below. The lower area is a pivot table and the upper blue part just ordinary Excel. The orange cell has the formula =IFERROR(VLOOKUP($B8,$B$19:$D$400,C$1,FALSE)/C$6,0)
In Power BI I understand how to build the pivot table as a Matrix. How would I build a normal table above that looks up a value in the pivot table and multiplies it by another value outside the pivot table?