Divide the "total" of one field in one table by the "total" of the same field in another table

[RumSwift]

Hello,

I'm new to PowerBI and my Google skills seem to have failed me on this one, so apoligies if I'm missing an answer for this on another thread.

Baically, I have two tables in my report Table 1 and Table 2:

Table 1 contains all of rows for "Cake Type" and a sum of cakes for each called "Sum of cake type". Table 2 contains 2 specific cake types and their sums.

In a nutshell, I want to be table to take the Totals of both tables and convert them into a percentage to say "Cake types 4 & 7 make up 12.82% of the total cakes. I want to do it this way as cake types can be added & removed at any point and we may change the cake types in Table 2 as well.

Is this possible? Is there an easier way to do this? 

P.s - This isn't actually for cake types. I just figured I should change the actual data as it's work related. 

[bcdobbs · Accepted solution]

Have a look at the example I've uploaded: Cake Example 

There is a single data table:

It uses "Edit Interactions" 

To turn of interaction on one table visual.

It then has the following two measures:

Sum of Cake Value = SUM ( Cake[Cake Value] )

% of Total Value = 
    DIVIDE (
        [Sum of Cake Value],
        CALCULATE (
            [Sum of Cake Value],
            REMOVEFILTERS(Cake)
        )
    )

 Resulting in this:

[ValtteriN]

Hi,

Here is one way to do this.

Example data:

I made a Summarized table out of this for my specific cake types 1 and 4.

Cake Sums = SUMMARIZE(filter(Cakes,Cakes[Cakes] in {"T1","T4"}),Cakes[Cakes],"Sum",SUM(Cakes[Sums]))

Since you already have the table 2 you don't need to do this.

Measures:

Cake Total = CALCULATE(SUM(Cakes[Sums]),ALL(Cakes)) //All cakes

Summarized total = CALCULATE(SUM('Cake sums'[Sum]),ALL('Cake Sums')) //sumarized cakes

Cake margin = DIVIDE(Cakes[Summarized total],Cakes[Cake Total]) //Percentage of summarized/all

End result:
I hope this helps and if it does consider accepting this as a solution!