topic Re: Summing when visualised in DAX Commands and Tips

Summing when visualised

EmilZPM — Tue, 17 Dec 2024 13:44:29 GMT

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.

Re: Summing when visualised

johnt75 — Tue, 17 Dec 2024 14:48:57 GMT

Try

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

Re: Summing when visualised

EmilZPM — Tue, 17 Dec 2024 15:04:04 GMT

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

But they are realted:

Re: Summing when visualised

johnt75 — Tue, 17 Dec 2024 15:14:50 GMT

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

Re: Summing when visualised

Anonymous — Wed, 18 Dec 2024 05:38:35 GMT

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.

Re: Summing when visualised

EmilZPM — Wed, 18 Dec 2024 07:14:44 GMT

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!

Re: Summing when visualised

EmilZPM — Wed, 18 Dec 2024 07:57:25 GMT

Thanks for the help anyways!