data for line y-axis combo chart

Hi richter_2100 ,
To show a fixed benchmark value as a line on the Y-axis of a combo chart in Power BI, you can create a DAX measure that pulls the benchmark value from a separate table based on the corresponding Qid. This allows you to plot your main metric (e.g., scores or results) as columns and display the benchmark as a line, even though the data comes from different tables. 

For this to work, the measure needs to reference the selected Qid from your main data table and retrieve the matching benchmark from the benchmark table. This approach works even if the tables aren't directly related, as long as the Qid is consistent in both.

Benchmark Line =
CALCULATE(
    MAX(Benchmark[Benchmark]),
    FILTER(Benchmark, Benchmark[Qid] = SELECTEDVALUE(MainTable[Qid]))
)