Average of filtered table visual

[Anonymous]

I have written a DAX measure which correctly gets the average of a table, however, now that I have added a visual level filter I need the average to now get the correct average according to what is actually showing on the table currently not what it originally showed without the visual level filter.

Current Average = 0.47%

Expected Average = 3.08%

Visual Level filter which I added

Current Output:

Expected Output (Checked via Excel):

DAX Code:

AverageRate = 

  AVERAGEX ( 

        VALUES (d_cam[owner_name]),

         [SASRate]

    )

[v-henryk-mstf]

Hi @Anonymous ,

Thanks for your solution. If the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

Looking forward to your feedback.

Best Regards,
Henry

[Anonymous · Accepted solution]

I solved the issue by created a calculated table using the SUMMARIZE function then did a DAX measure based on that calculated table

[Anonymous]

I am sure there are some other filters applying to the visual. get the dax query of the visual and check