Forum Discussion

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    3 years ago

    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's avatar
      adler_08
      New Member
      3 years ago

      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




  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.