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 multipying the 4 different levels (interm., propagation, sell, and stock)....95% * 96.2% = 91.39% INSTEAD of (95%*96.20%) = 95.67%

 

I've tried a few different approaches but I end up at 95%*96%*0 = 0 since there are times when there is only 1, 2, or 3 levels.

 

 

 

Thank for the help!!

 

 

 

-Maykel

General Comment
Tips and Tricks
Tutorial Requests

9 Replies

  • MattAllington's avatar
    MattAllington
    Community Champion
    7 years ago

    A DAX formula depends on the tables, columns and relationships. It is impossible to help you unless you provide all this information.  

    • Maykel's avatar
      Maykel
      Frequent Visitor
      7 years ago

      Hi Matt,

       

      Here is the Data

       

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

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

    Hi Maykel,

     

    Please provide a complete sample file.

     

     

    Best Regards,
    Dale