Forum Discussion
PeterQz
Jan 10, 2025Copper Contributor
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.
- PeterQzCopper Contributor
table