Forum Discussion
KrisB2019
7 years agoFrequent Visitor
Help Needed on Goals Reflecting in Matrix
I'm struggling with my goals showing on both the higher level and the lower level when my list is expanded. I have included details below and the measure I created in the hopes that the goal would only show on the higher level. I thought it would be an easy fix, but I'm stumped.
You can see in the above that the higher level goal is listed as it should be, but when I expand the list to the lower level, the goal appears on each one. I have a relationship between the upper level and the goal, not the lower level and goals.
The measure I created to try and address this is:
Lead channel goal only = IF(NOT( ISFILTERED( 'leadsourcechannel'[amsen_name])), SUM ('Lead Goal'[Lead goal]))
I'm hoping someone can help me, thanks so much!
Kristi
No RepliesBe the first to reply