Forum Discussion
Summing when visualised
Hi all,
I don't know if the title is fitting, but I don't know what to call my issue.
I am working on a report tool, to show how much our different partners have been promoted in our Newsletter.
I have two tables, one containing the plan for the communication, what spot the different partners have, and which target groups they are sent to. The other includes the target groups and the size of these.
The two tables are connected by target group.
I want to make a table, that shows how many people the different partners has been promoted to.
This is done by taking the size of the target group connected to the email the partner is in, and the weight, which indicates how many % we estimate will get to this spot.
pop*weight=exposure
This is all fair and well, when I "population" in the table, but as soon as I remove it, it summarises the population of all the target groups, when it calculates exposure.
I can't seem to find the solution to this.
Ideally all I want to show in the table is: "Mail Date", "MailPartner", "Prio" and "exposure".
Exposure=
CALCULATE(
SUM(TargetGroups[Population])*SUM(Redaktionsplan[Vægtning Email])
)
I hope this is enough information, but otherwise let me know, and I will try and provide more info.
Hi EmilZPM , hello johnt75, thank you for your prompt reply!
The filters applied to TargetGroups table will affect Redaktionsplan table, but not vice versa.
If possible, change the cross-filter direction to Both to compare the result:Best regards,
Joyce
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
It looks like you're connected to a composite model, and I'm not sure if report measures can use RELATED in those circumstances. Try and get the measure added to the actual model if you can, it certainly should work there.
If getting it added to the model is not an option, you could use LOOKUPVALUE instead.
Exposure = SUMX ( Redaktionsplan, Redaktionsplan[Vægtning Email] * LOOKUPVALUE ( TargetGroups[Population], TargetGroups[MasterTargetGroup], Redaktionsplan[target group email] ) )Thanks for the help anyways!
Hi EmilZPM , hello johnt75, thank you for your prompt reply!
The filters applied to TargetGroups table will affect Redaktionsplan table, but not vice versa.
If possible, change the cross-filter direction to Both to compare the result:Best regards,
Joyce
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Oh god... You are right! I completely missed that one! Was trying all sorts of things, and that was the solution! Thank you so much!
Try
Exposure = SUMX ( Redaktionsplan, Redaktionsplan[Vægtning Email] * RELATED ( TargetGroups[Population] ) )Oh, I never even seen "RELATED" before.
But it gives me the following error:But they are realted:
