weighted average and exception

Question

Hi,I want to develop a measure to calculate average and weighted average at the same time. I am using 3 slicers for selection (Month, Group and Class).If I don't select anything in Class slicer, then it should calculate the weighted average based on the "average" value per class and the number of students. However, Class C should not be considered in the calculation. For example; for the selection of January 2021 in the month slicer and not select anything in Class slicer, it should provide:ClassA: (240+290)/2=265 and&nbsp;ClassB: (120+60)/2=90 and the weighted average should be:((265*80)+(90*60))/(80+60) =190If I select ClassA, then it should provide the result 265, which is the average, not the weighted average.This is the data.GoalHighestLowestAverageInvolvedStudentsTotalStudentsGroupClassMonth240250200240550G1ClassA01.2021320330280290430G2ClassA01.202113014050120720G1ClassB01.202180904060340G3ClassB01.20213003002002601060G1ClassC01.20213003002002601070G4ClassC01.2021250260200240445G1ClassA02.2021330340290290535G2ClassA02.202113013060130620G1ClassB02.2021901006070445G3ClassB02.20213003002002701050G1ClassC02.20213003002002701080G4ClassC02.2021Thanks in advance!

anonymous · Accepted Answer

Hi&nbsp;IF&nbsp;,
&nbsp;
Please create measures like below to meet your needs:
Measure = 
VAR _selclass =
    SELECTEDVALUE ( 'Table'[Class] )
VAR _avg =
    CALCULATE (
        AVERAGE ( 'Table'[Average] ),
        FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Class] = _selclass )
    )
VAR _avg1 =
    IF ( _selclass = "ClassC", BLANK (), _avg )
VAR _wavg =
    SWITCH ( _selclass, "ClassA", _avg1 * 80, "ClassB", _avg1 * 60 ) / 140
RETURN
    _wavgweighted average = sumx(VALUES('Table'[Class]),[Measure])
&nbsp;

&nbsp;
A sample PBIX. for your reference is attached.
&nbsp;
If I have not understood your needs correctly, please do not hesitate to inform me.
Hope it helps,
Community Support Team _ Caitlyn
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
&nbsp;

Forum Discussion

weighted average and exception

2 Replies

Related content

Calculating Weighted Average

Weighted Average DAX

Weighted Average Measure

Weighted average by month

Weighted Average

Goal	Highest	Lowest	Average	InvolvedStudents	TotalStudents	Group	Class	Month
240	250	200	240	5	50	G1	ClassA	01.2021
320	330	280	290	4	30	G2	ClassA	01.2021
130	140	50	120	7	20	G1	ClassB	01.2021
80	90	40	60	3	40	G3	ClassB	01.2021
300	300	200	260	10	60	G1	ClassC	01.2021
300	300	200	260	10	70	G4	ClassC	01.2021
250	260	200	240	4	45	G1	ClassA	02.2021
330	340	290	290	5	35	G2	ClassA	02.2021
130	130	60	130	6	20	G1	ClassB	02.2021
90	100	60	70	4	45	G3	ClassB	02.2021
300	300	200	270	10	50	G1	ClassC	02.2021
300	300	200	270	10	80	G4	ClassC	02.2021