AGGR

[Arild]

Hello,

I have a table with revenue, liability (factor), and calculated liability pr customer. 

In my table this works fine and I get a total of how much liability we have. 

Then I am trying to make a "Gauge" where I show how much liability we have in total compared to revenue. 

However this only works for me when I have selected a customer. I assume this is because I dont use the Aggr formula - but I dont find out how that work. 

Example: 

Customer, Revenue, Liability (factor), Liability

cust 1        , 10 000      , 2                            , 20 000

Cust 2        , 100 000   , 0,5                        , 50 000

Total          , 110 000   ,                                ,70 000

How can I make this into a Gauge where the liability is calculated to 70 000?

[hic · Accepted solution]

You don't write how "Revenue" is calculated, so I assume that it is Sum(Revenue). If so, the following could work:

Sum(Aggr(Sum(Revenue*[Liability (factor)]),Customer))