Forum Discussion

EmilZPM's avatar
EmilZPM
Frequent Visitor
1 year ago
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...
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

     

     

     

johnt75's avatar
johnt75
Super User
1 year ago

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's avatar
    EmilZPM
    Frequent Visitor
    1 year ago

    Thanks for the help anyways!