Related is not working for some reason...

[aze]

Hello, for some reason related measure is not working and I'm out of ideas why.

I have this formula, which supposes to work:

Keyword_2_profitability = ('Keywords statistika'[Weight]) * RELATED('Nuotraukų pardavimai'[Earnings])

Table 'Nuotraukų pardavimai'[Earnings] has unique values. It has 1 to many relationship:

What else might be wrong?

[v-lionel-msft · Accepted solution]

Hi @aze ,

Please refer to my .pbix file, which may help you.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AlB]

@aze 

Can you share the pbix? If necessary with mock data but reproducing the issue

Try this in the meantime:

1. Set the relationship cross filter direction to SINGLE. Setting it as Both is asking for trouble unless you know very well what you are doing.

2. 

Keyword_2_profitability  V2 =
SUMX (
    'Keywords statistika',
    'Keywords statistika'[Weight] * RELATED ( 'Nuotraukų pardavimai'[Earnings] )
)

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.

[aze]

Also, than I did measure like this

Keyword_profitability = SUM('Keywords statistika'[Weight]) * SUM('Nuotraukų pardavimai'[Earnings])

I got something, but calculation was not correct.

In this table individual calculation is good, but Totals is not. And that's obviuos, because formula sums everything and only then multiplies. And I need just individual rows to be multiplied, so I could use this measure in charts where I can't add the titles or ID's (like in this table)

[AlB]

Hi @aze 

RELATED needs row context. You do not have it in a measure. You'll need to do some sort of aggregation.Wat exactly are you trying to do? If you show an example it will help clarify

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.

[aze]

Each Keyword has some kind of weight. In the other table, there is the list of unique names (connected by ID) which has an Earnings column. So I want to multiply Weight * Earnings. So that each line in "Keywords statistika" table would have this new number.