Forum Discussion

Maykel's avatar
Maykel
Frequent Visitor
7 years ago

Multiplying Rows & Columns to calculate Yield

Hello Fellow PBI Users!   I always seem to overcompliate and confuse myself using DAX but I was hoping to get some help.   What I would like to achieve is a total yield for a specifc group by mul...
General Comment
Tips and Tricks
Tutorial Requests
MattAllington's avatar
MattAllington
Community Champion
7 years ago

Yes, that is the data. But which tables, which columns, what relationships?  Power BI is not like Excel. You can’t look at numbers on the page like you have presented and work out the formula. You must consider the 3 things I mentioned. 

Maykel's avatar
Maykel
Frequent Visitor
7 years ago

Is this enough info? Thanks.

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    7 years ago

    Hi Maykel,

     

    Please refer to the snapshot below. Is it what you'd like?

    Measure = PRODUCT(Table1[Program Yield])

    Multiplying_Rows_Columns_to_calculate_Yield

    Best Regards,
    Dale

    • Maykel's avatar
      Maykel
      Frequent Visitor
      7 years ago

      Hi Dale,

       

      Thanks for the quick reponse. Here is what I am getting...

       

      Why is the cal off? Could it be because of a relationship table?

       

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee
        7 years ago

        Hi Maykel,

         

        Did you mean the blank of "Plant Group"? Yes, mostly because of the relationship. Some values don't have matches. Please check out.

         

         

        Best Regards,
        Dale