Summing when visualised

[EmilZPM]

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.

[Anonymous · Accepted solution]

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.

[EmilZPM]

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!

[johnt75]

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]
        )
)

[EmilZPM]

Thanks for the help anyways! 

[johnt75]

Try

Exposure =
SUMX (
    Redaktionsplan,
    Redaktionsplan[Vægtning Email] * RELATED ( TargetGroups[Population] )
)

[EmilZPM]

Oh, I never even seen "RELATED" before. 
But it gives me the following error:

But they are realted: