Calculate Average of Column with Two Filters

[JDartz]

Hey, everyone! 

Brand new to Power BI; tired looking for this solution but can't seem to find it.

Basicially I'm trying to create an avearge measure of a specific column, but with two filters engaged for the same column. 

I have been able to calculate the Average in that column for ONE filter, but can't seem to figure out how to calculate for two filters. Here is the formula for the one filter calculation that works:

AVG TX IO =

CALCULATE (

    AVERAGE ( '2024 Raw Data (2)'[TX] ),

    FILTER ( '2024 Raw Data (2)', '2024 Raw Data (2)'[ Location] = "In-Office" )

)

[Ashish_Mathur · Accepted solution]

Hi,

Modify the measure to

AVG TX IO = CALCULATE(AVERAGE ( '2024 Raw Data (2)'[TX] ),'2024 Raw Data (2)'[ Location] = "In-Office"||'2024 Raw Data (2)'[ Location] = "Out-Office")

Hope this helps.

[JDartz]

Yes! Taking the FILTER function out and adding || worked! Much appreciated!!

[Ashish_Mathur]

You are welcome.

[ryan_mayu]

maybe try to use && to apply the second fileter

AVG TX IO =

CALCULATE (

    AVERAGE ( '2024 Raw Data (2)'[TX] ),

    FILTER ( '2024 Raw Data (2)', '2024 Raw Data (2)'[ Location] = "In-Office"  && xxxx )

)