Forum Discussion

PeterQz's avatar
PeterQz
Copper Contributor
Jan 10, 2025

SSRS Measure aggregation

Hi community, It is my first post, so I'm working with report builder, I have a semantic model on power bi service so the report is live connection.

In the  model I have the dimensions and measures:

dimension: Country, city

Measures: stock, orders, avg sell this ultimate is actually:  function ( orders  , stock ).

So in the report I summarized the measures with total.

 

 

 So the Sum function measures are OK, but the avg sell NOT(aggregation) the values are wrong, so which aggregate should be work? if the measure is operation between orders and stock

Is it possible to use measures predefined in model?

or do I have to make a custom measure in report builder (expression) ?

 

 

 

thanks in advance. 

Resources