Forum Discussion
Solved
simple calculation based on aggregate value reg,.
Hi, I surprise if i can do a calculation over an aggregated value in power BI. Please see to the below screen shot & table. I need that 'AB on Total' value to be calculated on run in Power BI. Is it...
If you have data as below, you would first pivot the table.
Then create and apply two measures in a Matrix visual.
Total = SUM([A]) +SUM([B])+SUM([C]) AB on Total = (SUM([A])+SUM([B]))/[Total]
Eric!
Thanks for that solution. It worked for me :)
Great to hear that. :)