Forum Discussion
Solved
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 Newsl...
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.
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!
