Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello, for some reason related measure is not working and I'm out of ideas why.
I have this formula, which supposes to work:
What else might be wrong?
Solved! Go to 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.
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.
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. |
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)
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. |
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.
User | Count |
---|---|
87 | |
84 | |
67 | |
62 | |
57 |
User | Count |
---|---|
138 | |
112 | |
94 | |
82 | |
71 |