Insufficient memory to display a simple output

[HankCostner]

I have two measures, 

calc1 = if( ISINSCOPE( 'schn Product'[ProductCode] ), 2, BLANK() )

calc2 = 

if( ISINSCOPE( 'schn Product'[ProductCode] ), Sum( 'production'[qty] ), BLANK() )

For some reason, calc1 is having memory issues, despite the simple output. Has anyone encountered this before? I can't access DAX Studio (company laptop, not authorized software). 

[Anonymous]

Hi @HankCostner 

Your metrics don't look complicated. Since you mentioned that you cannot access DAX Studio, you might consider using Performance Analyzer in Power BI Desktop to review the performance of your report pages and see if is indeed the root cause of the memory issue. This tool can give you insights into how each visual is performing and might point you towards a solution. Here's how you can use Performance Analyzer:Use Performance Analyzer to examine report element performance in Power BI Desktop - Power BI | Micr...

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[HankCostner]

same thing happens here, insufficient memory

calc =

if( ISINSCOPE( 'schn Product'[ProductCode] ), MIN( 'vw_Production_2Years'[BaseOrderNumber]) & " " & MIN( 'vw_PlannedSchedule'[BaseOrderNumber]) , BLANK() )

if I take out the space, it works without a problem

calc =

if( ISINSCOPE( 'schn Product'[ProductCode] ), MIN( 'vw_Production_2Years (3)'[BaseOrderNumber]) & MIN( 'vw_PlannedSchedule Extrusion'[BaseOrderNumber]) , BLANK() )