Forum Discussion

jacccodezwart's avatar
2 years ago

Power BI Report Builder Query 'explodes' after adding measure

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

 

 

No RepliesBe the first to reply