New average measure rolls up when I drill 'up' in a visual

[JediMole]

The behavior of this visual is creating confusion.  The averages for attendees is right in the screen shot below, but if\when the user collapses the the visual, the average works\shows for all the events, (hence the confusion!)

Is there a way to stop that from happening?

this is the cal on the measure

Average per Total Attended =
AVERAGEX(
KEEPFILTERS(VALUES('Combined Event Data'[Total Attended])),
CALCULATE([Sum of Total Attended])
)

[Elena_Kalina]

Hi @JediMole 

The issue you're experiencing occurs because Power BI treats collapsed totals differently from expanded rows.

When you collapse the visual:

1. The row-level context is lost

2. Your VALUES() function returns all values instead of filtered ones

3. The average recalculates across all data

Try this measure

Average per Total Attended = 
IF(
    HASONEVALUE('Combined Event Data'[Client]),
    // Row-level calculation
    DIVIDE(
        [Sum of Total Attended],
        [Count of Events]
    ),
    // Grand total calculation
    DIVIDE(
        SUM('Combined Event Data'[Total Attendees]),
        SUM('Combined Event Data'[Total Events]),
        0
    )
)

[JediMole]

Playing with this now.  DAX and measures are Greek to me so I'm learning this as I go!  That said I think I need to make a total events measure to, to get this to work properly so I'm doing that first.