Avrege with filters

[LeaRupnik]

Hello, 

I'm new in Dax formula, a would like to ask how to calculate an average with a filter. 

In Power BI a get a value of 1,251 in excel is this value a 1,267. what I do wrong. 

Please help.

[v-alq-msft]

Hi, @LeaRupnik 

Based on your description, you may create a measure as below. The pbix file is attached in the end.

Table:

You may create a measure as below.

Result = 
AVERAGEX(
    'Table',
    'Table'[Value]
)

Result:

Best Regards

Allan

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

[Anonymous]

@LeaRupnik It would be good if you had given the sample table anyways i hope this will help you

you can make use of the below formula

Average=calculate(average(sum(salestable[salesunit])))

Appreciate your Kudos, Press the thumbs up button!!👍

Regards,

Husna

[LeaRupnik]

Hello @Anonymous  and @v-alq-msft 

in link is an example of what we like to do. 

https://drive.google.com/drive/folders/1kNxDiE9t47AH2H7JZuTLLz1USbrCx7kD?usp=sharing

THX

Lea

[v-alq-msft]

Hi, @LeaRupnik 

I am sorry for the late reply. I modified data based on your sample data. The pbix file is attached in the end. You may create a measure as below.

Measure = 
AVERAGEX(
    SUMMARIZE(
        List1,
        List1[Column1],
        "Result",
        AVERAGE(List1[Column2])
    ),
    [Result]
)

Result:

Best Regards

Allan

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