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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Latermocdelo
New Member

How to calculate Average with Filters

Good morning,

 

I'm currently Power BI beginer and I try to learn how to use it in the good way.

 

I try to calculate average of error percentage with filters.

 

This is my data tables :

'Table test FX9600' :

Latermocdelo_0-1659512896821.png

 

'Table test LRU1002':

Latermocdelo_1-1659512955256.png

 

And my results table :

Latermocdelo_2-1659512998230.png

 

 

I want to calculate the average of error percentage (column:"Moyenne % erreur") with specific "Session" and "Type de lecteur".

The data is on my two other tables.

I try to solved this problem with the "SWITCH" command, but I think there is a better (faster) way to do this.

 

This is my command which works :

 

Moyenne % Erreur = SWITCH('Param Session'[Type de lecteur],
    "FX9600", SWITCH( [Session], 
                    "Session 0", CALCULATE(AVERAGE('Table test FX9600'[Erreur %]),'Table test FX9600'[Session]="Session 0"),
                    "Session 1", CALCULATE(AVERAGE('Table test FX9600'[Erreur %]),'Table test FX9600'[Session]="Session 1"), 
                    "Session 2",CALCULATE(AVERAGE('Table test FX9600'[Erreur %]),'Table test FX9600'[Session]="Session 2")
                ),
    "LRU1002",  SWITCH( [Session], 
                    "Session 0", CALCULATE(AVERAGE('Table test LRU1002'[Erreur %]),'Table test LRU1002'[Session]="Session 0"),
                    "Session 1", CALCULATE(AVERAGE('Table test LRU1002'[Erreur %]),'Table test LRU1002'[Session]="Session 1"), 
                    "Session 2",CALCULATE(AVERAGE('Table test LRU1002'[Erreur %]),'Table test LRU1002'[Session]="Session 2")
                ),
..........
)

 

 

Someone has any idea to simplify (and automate) this ?

Thanks in advance

Quentin

1 REPLY 1
v-easonf-msft
Community Support
Community Support

Hi, @Latermocdelo 

For the nesting of 'switch' in this measure, I'm afraid it can't be simplified further in DAX.

Best Regards,
Community Support Team _ Eason

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.