Error when using Dax formula in a line Chart (SUMX, SUMMARIZE)

[Anonymous]

Hello everybody,

I have a Fact table that contains 200Millions rows

I have a problem with a dax formula when i put it in a line Chart with axis = week

The dax formula ->

KPI =  SUMX(DISTINCT(SUMMARIZE(FILTER('Fact_Table','Fact_Table'[level]="Low"),'Fact_Table'[id_cv],'FACT_Table'[Server_id])),1)

the error is : 

I tried this formula too, and i have the same problem :

KPI = CALCULATE(COUNTROWS(GROUPBY('Fact_Table';'Fact_Table'[id_cv];'Fact_Table'[Serveur_id]));'Fact_Table'[level]="Low")

I have to filter on a specific date for the graph to display correctly

Any help with this would be appreciated.

Thank you 

[Anonymous]

Hi  @Anonymous ,

Imported data may be too much, Try removing columns / rows that you may not need in your table and refreshing. Also, check to see if you have relationships set if not you may have an underlying cartesian product.

https://community.powerbi.com/t5/Service/Memory-error-Memory-Allocation-failure/m-p/278131/highlight/true

https://windowsreport.com/memory-error-allocation-failure/

Or use Dax studio to detect the content and number of queries issued by Power BI Desktop.

https://daxstudio.org/

https://www.sqlbi.com/articles/capturing-power-bi-queries-using-dax-studio/

Best Regards,

Liu Yang

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

[amitchandak]

@Anonymous , Try like

countrows(SUMMARIZE(FILTER('Fact_Table','Fact_Table'[level]="Low"),'Fact_Table'[id_cv],'Faits_PVM'[Server_id]))

[Anonymous]

Hello @amitchandak, 

Thank you for your answer.

the formula returns me result = (BLANK)

[amitchandak]

@Anonymous , do you have some values after filter

'Fact_Table'[level]="Low" 

[Anonymous]

@amitchandak Sorry, I tested with the wrong formula that's why i had a blank.

with your formula, it works when i use the formula in a card, but when i use it in the line Chart with axis = week it's shows me the same error 

If I want the chart to show me a result and remove the error, i have to apply a filter to reduce the data and in this case it works. but I want it to display the result without applying a particular filter