Forum Discussion

KrisB2019's avatar
KrisB2019
Frequent Visitor
7 years ago

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