Need help in Sum of average Dax

[Anonymous]

Hi, I am looking for a measure to solve the below problem:

Name	Call type	Attendees
Neeraj	F2F	50
Neeraj	Digital	50
Neeraj	Events	50
Gaurav	F2F	60
Gaurav	Digital	60
Ajay	F2F	70

Above is the sample table as our company table is very big. In above table we the number of attendees will be same for each name but when anyone choose multiple names then it should sum the attendees..for e.g. THere are total 50 Attendees who attended event organized by Neeraj and there are 110 attendees who attended the event organized by Neeraj and Gaurav.

I want to a meausre which can perform following:

I will create 2 slicers from above table "Name" and "Call Type"

Now, When I choose Neeraj from Slicer Name then Number of attendees should come as 50. Call type slicer is All

But, When I choose Neeraj and Gaurav from Slicer Name then Number of attendees should come as 110. Call type slicer is All

[v-rzhou-msft]

Hi @Anonymous ,

Here I create a sample to have a test.

Measure:

Sum of average =
VAR _STEP1 =
    SUMMARIZE (
        'Table',
        'Table'[Name],
        "Average",
            CALCULATE (
                AVERAGE ( 'Table'[Attendees] ),
                ALLEXCEPT ( 'Table', 'Table'[Name], 'Table'[Call type] )
            )
    )
RETURN
    SUMX ( _STEP1, [Average] )

 Result is as below.

By Default, measure should return 50+60+50 in my Sample.

Select Neeraj and Gaurav in Name:

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

expected result measure: =
SUMX ( SUMMARIZE ( Data, Data[Name], Data[Attendees] ), Data[Attendees] )

[Anonymous]

Thank you so much for your help and time. It worked 🙂