How to create link between measure and a new table

[LisaZhai]

I have created a few measures, for example the profit margin, salary ratio etc, and I manually entered a table which is the industry benchmark profit margin and salary ratio, I'd like to compare these data in one graph which means I have to tell Power BI there's a connection between the measure and the table. Any suggestions?

[lc_finance · Accepted solution]

HI @LisaZhai ,

you could create measures for the benchmark. Example:

Profit Margin Benchmark Measure = AVERAGE ('Profit Margin Benchmark Table'[Profit Margin])

And also add measures comparing your ratio with the benchmark.

Profit Margin vs Benchmark = [Profit Margin] - [Profit Margin Benchmark Measure]

Hope this helps.

Regards,

LC

Interested in Power BI finance templates? Check out my blog at www.finance-bi.com