Forum Discussion
Rate Consolidation
Hi, I'm trying to make a consolidation with Power BI.
I want grand total to look like this. Columns A and B adding generally. A/B is created in Power BI. 0.639(690,000/1,080.0301) is the value I want to have. But in Power BI, It's 1,94 (0,378+0,734+0,828).
If anyone can help it would be great, thank you 🙂
Hi Anonymous ,
I guess that you are building a calculated column. Right?
Calculated columns you create will work as other columns in your table. Therefore the total value will just use the "Sum" value by default.
To meet your requirements, please create a measure. It will pass the same calculation logic to the total field.
A/B Measure = DIVIDE ( SUM ( 'Table'[A] ), SUM ( 'Table'[B] ) )Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Anonymous , are you looking for column header grouping
https://www.daxpatterns.com/dynamic-segmentation/
https://community.powerbi.com/t5/Desktop/Matrix-Display-Values-above-Columns/td-p/256905Hi Anonymous ,
I guess that you are building a calculated column. Right?
Calculated columns you create will work as other columns in your table. Therefore the total value will just use the "Sum" value by default.
To meet your requirements, please create a measure. It will pass the same calculation logic to the total field.
A/B Measure = DIVIDE ( SUM ( 'Table'[A] ), SUM ( 'Table'[B] ) )Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
