Multiplying Rows & Columns to calculate Yield

[Maykel]

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

[v-jiascu-msft]

Hi @Maykel,

Could you please mark the proper answers as solutions?

Best Regards,

Dale

[v-jiascu-msft]

Hi Maykel,

Please provide a complete sample file.

Best Regards,
Dale

[MattAllington]

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

[Maykel]

Hi Matt,

Here is the Data

[MattAllington]

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]

Is this enough info? Thanks.

[v-jiascu-msft]

Hi @Maykel,

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

Measure = PRODUCT(Table1[Program Yield])

Best Regards,
Dale

[Maykel]

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]

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