Measure is adding entries from relationship table, I only want it to apply to the data set entries

[NNaj]

Hi All,

I have written this measure that adds values of specific trade ID's.

Value = CALCULATE(SUM(Table[Absolute value]),Table(Table[ID]), Table[WIN_FLAG] = TRUE()).

In another table, I have ID's and company names to help identify which companies are being referred to. In this table there are more companies and ID's than in dataset. This is where I believe my problem is arising. (e.g. ID 1 is company A, ID 2 is company B,..)

When I add the measure above to my table, it correctly computes the values for the ID's in my data set but it also adds rows to my table for the other companies not referred to in my dataset. How can I avoid this?

Apologies if I havent worded my problem suitably, its a tough one to explain.

Any help will be appreciated.

[Washivale · Accepted solution]

Hi @NNaj ,

First thing you would need to check is relationships between both tables (ID Table and Value table).

I assume your win flag and value table is same.

once you have relationship set on both tables, use ID from your ID table in Your visual and below measure.

Create below two measures and check if any renders correct results for your dataset.

Value = CALCULATE(SUM(Table[Absolute value]), Table[WIN_FLAG] = TRUE())

value1 = sumx(Filter( Table,  Table[WIN_FLAG] = TRUE()), Table[Absolute value])

let me know if it works.

Thank You,

Washivale