Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

DAX Cross Table Row Calculation help

I have the following table setup:   We have a weighted calcualtion where we want to apply the percetages to get portion values. So for an event we want to know the weighted count, where weigh...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Anonymous,

 

Based on your relationship, these tables connect with one to many relationships. It is impossible calculate on row level and sum up these values.(you can't accurate mapping these records at row level)

 

In my opinion, you need to summary multiple records first, then calculate on these summarized value.

So your formula should be similar as '1 * SUM([Project].[Project %]) * SUM([Project Business Group][Busness Group %]) * SUM([Region]. [Region %])' (these not the accuracy formula)

 

Regards,

Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

That logic won't work as it summs the percentages, then multiplies them.

 

I didn't think it was possible anyway. In our olap version of this data, we used multiple fact tables. I may have to implment a similar solution.

 

 

Thanks for looking into this problem for me