Server Side Aggregations with POWER BI Report BUilder
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.