I need to be able to take the totals from 2 visuals and use them in a formula

[TallKewlOnez]

I have two visuals (each with different filters), then use the total from each in a separate column.

so I would like to be able to add a column  % of total expenses

salarys (table visual) (filter on label for aa,bb))

label       Amount    % of total expenses   

aa          $5             12.5 formula = 5/40×100

bb         $10           25 formula = 10/40×100

             $15  (t1 ) 

Misc Expenses     (table visual) (filter on label for cc,dd))

label         Amount    % of total (T1+T 2 (25+15) )   

cc            $15             37.5 formula = 15/40×100

dd           $10             25 formula = 10/40×100

       $25  (t2)   

Total Expenses = 40

Please help

[Icey · Accepted solution]

Hi @TallKewlOnez ,

You need to use ALL to calculate the total value.

% of total = SUM ( 'Table'[Amount] ) / CALCULATE ( SUM ( 'Table'[Amount] ), ALL ( 'Table' ) )

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

I would create a new measure that adds ALLSELECTED(salaries) and ALLSELECTED(expenses), and that you can then use in the computation for the measure of the percentage against total.