Please check the below picture and the attached pbix file.
One of ways is to create a supporting table like below.
Expected result measure: =
VAR _attendcount =
MAX ( Attended[Attended] )
VAR _eventscountbymembers =
DISTINCT ( Data[Members] ),
"@eventscount", CALCULATE ( COUNTROWS ( DISTINCT ( Data[Event] ) ) )
VAR _filtertable =
FILTER ( _eventscountbymembers, [@eventscount] = _attendcount )
VAR _allmembers =
COUNTROWS ( DISTINCT ( Data[Members] ) )
DIVIDE ( COUNTROWS ( _filtertable ), _allmembers )
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Go to My LinkedIn Page