Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
IHam
Helper III
Helper III

calculate average but don't include the value

I am trying to calculate a mean for an examination sitting but finding the average of values not including the value itself in dax. 

Any help would be great.

To illustrate:

subjectsittingmark"average"
mathssummer 2023 60(70+80+90+50)/4
frenchsummer 2023 70(60+80+90+50)/4
englishsummer 2023 80(60+70+90+50)/4
biologysummer 2023 90(60+70+80+50)/4
historysummer 2023 50(60+70+80+90)/4
1 ACCEPTED SOLUTION
Dangar332
Super User
Super User

HI, @IHam 

 

Measure 2 = 
var a = CALCULATE(SUM(sub[mark]),sub[subject]<>MAX(sub[subject]))
var b =CALCULATE(DISTINCTCOUNT(sub[subject]),sub[subject]<>MAX(sub[subject]))
return 
DIVIDE(a,b)

 

Dangar332_0-1698828629299.png

 

View solution in original post

3 REPLIES 3
IHam
Helper III
Helper III

Many thanks to both of you - they both work but the second solution is the one that seems to match my set-up.

 

ThxAlot
Super User
Super User

ThxAlot_0-1698829241857.png



Expertise = List.Accumulate(


        {Days as from Today},


        {Skills and Knowledge},


        (Current, Everyday) => Current & Day.LeanAndPractise(Everyday)


)



Dangar332
Super User
Super User

HI, @IHam 

 

Measure 2 = 
var a = CALCULATE(SUM(sub[mark]),sub[subject]<>MAX(sub[subject]))
var b =CALCULATE(DISTINCTCOUNT(sub[subject]),sub[subject]<>MAX(sub[subject]))
return 
DIVIDE(a,b)

 

Dangar332_0-1698828629299.png

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.