topic Re: Error when using Dax formula in a line Chart (SUMX, SUMMARIZE) in DAX Commands and Tips

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

Anonymous — Wed, 24 Nov 2021 14:04:57 GMT

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

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

amitchandak — Wed, 24 Nov 2021 10:51:48 GMT

Anonymous , Try like

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

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

Anonymous — Wed, 24 Nov 2021 10:58:53 GMT

Hello amitchandak,

Thank you for your answer.

the formula returns me result = (BLANK)

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

amitchandak — Wed, 24 Nov 2021 11:13:43 GMT

Anonymous , do you have some values after filter

'Fact_Table'[level]="Low"

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

Anonymous — Wed, 24 Nov 2021 13:13:04 GMT

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

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

Anonymous — Mon, 29 Nov 2021 07:27:44 GMT

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.