How to make a measure considering index

[PatMic090]

I'm trying to figure out how can I make a needed measure.

I have created index in the same table where Comp measure is. Sales measure is from different table, but those two tables have relationship. I want to calculate the Total as Comp * Sales.

So if comp is 0 the Total should be 0, if it's one then I should be multiplied by 1.

I would need that calculation to use with other category later. How can I achieve that? 

[pi_eye]

Hi @PatMic090  this is actually a common model to use, to have a table just for measures.

In Power BI, measures aren't strictly "connected" to a table as they can refer to many fields from diffrerent tables. See https://www.phdata.io/blog/creating-a-measures-table-in-power-bi/ for more information

Can you give examples of the data, tables, and the results that you are expecting?

Pi

[pi_eye]

Hi @PatMic090 

If the tables are joined, you should just be able to create a measure which combines the two measures from different tables.

new measure = [Comp Measure] * [Sales measure]

If this isn't returning the result you expect, can you elaborate on how the tables are joined?

Pi

[PatMic090]

It seems to be my mistake, actual relationship is not correct. The thing is that Sales measure is in Metrics table, which is not connected to anything (there are only measures). I don't have access how they were created because the data is from Power Bi datahub. Is there any other solution?