Server Side Aggregations with POWER BI Report BUilder

Hi,

I am trying to create my first report in Power BI Report Builder.

I am connecting to our Azure Analysis Services (Tabular) model.

The measure "Catchment Rate" is non-additive, i.e. when I display subtotals and use a sum, it will not give me the right results. I understood there is an Aggregate function, but when I use that function the cell remains blank.

Is there anyone that can help out?

Best,

P