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
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