Hi all,
If have a report builder report that uses a query on a SSAS Tabular cube.
All works fine, until I add a new measure.
When I add this new measure all memory is used and the report crashes.
The measure works in power bi like in this table :
The measure (for example) #ArrivedLate is a count of all the rows having the the value 'Late' in a calculated column of the SSAS model. And the calculated column is a formule based on several time registrations.
All I want to do is recreate the table using the same measures, like this :
The column NumberOfTransports is a measure in the SSAS Tabular model as well, but this is a simple count formula. Same goes for the measure avgTimeOnTerminal, TotalLoadingTIme, TotalTimeOnTerminal which are all simple calculations.
So why does my query explode and use all memory when I add the measure #ArrivedEarly ?
Thanks in advance.
Jacco
