Average Column

[adler_08]

Hi Good Evening,

I want to create an average measure for this but not working.

How can I solve this?

Thank you.

[Anonymous]

Hi @adler_08 ,

Please have a try.

Create a measure.

measure=averagex(filter(al(table),table[id]=selectedvalue(table2[id)),table[value])

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Polly

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

[Greg_Deckler]

@adler_08 Could be a missing relationship, hard to tell. Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[adler_08]

Hi sir Greg,

Good Morning,

I have two table, the first table is the olist_order_review_dataset the second is the olist_orders_dataset, I want to create a measure to get the average of the review score. The relationship of the 2 table is the Order ID only.

I want to get the average review by delivery status but it show the same average review.

Thank you

[adler_08]