Forum Discussion
Average Column
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.
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
