User Profile

GerlofVisser

Helper I

Joined 6 years ago

26 Posts2 Solutions

View All Badges

User Widgets

Contributions

Re: SumX and Visual "has exceeded available resources"
After further searching, I have created calculated columns in the table where the additional information resides. This speeds up the calculation and the error doesn't exist anymore. Happy to elaborate on this, if anyone would like to know more.
5 years ago Place Service
1.5KViews
0likes
0Comments
SumX and Visual "has exceeded available resources"
Hello again, I have an issue with the visuals after an update of my dataset. In the old situation I had one table([COST_INT_CTR_DETAIL]) with an interest percentage for each asset and another table([FLOW_DATA_VALUE]) with a daily value (gross sales). To correct for our interest I used the following measure. net Share Gas Nm3 = CALCULATE(sumx( cost_int_ctr_detail, cost_int_ctr_detail[_Percentage]*[Gross Sales Gas Nm3]), Facility_Lookup[Facility_ID]) Where [Gross Sales Gas Nm3] = CALCULATE(SUM(flow_data_value[_Gas_Sales_Nm3]), flowID_Lookup[_Gas Sales Daily Data]=1) (The columns with an "_" are calculated columns created by me for some filtering) Then after conversion to boe (multiply with 0.0062897) and add Net share oil (this measure uses a similar logic), I show a cumulative graph of this measure using the following measure: Net Cumulative Sales = CALCULATE( [Total Net share Sales boe],DATESYTD(Rolling_Calendar[Date])) In the new set-up the daily production values also have an interest percentage in the same table([FLOW_DATA_VALUE]). So the new measure looks as follows Net Share Gas Nm3 = sumx(flow_data_value, [Actual Interest Gas Export]*[Gross Sales Gas Nm3]) Where: Actual Interest Gas Export = divide(CALCULATE(sum(flow_data_value[Production_Interest]),flowID_Lookup[_Gas Export Daily Data]=1),100) And: Gross Sales Gas Nm3 = CALCULATE(SUM(flow_data_value[_New_Gas_Sales_Nm3]), flowID_Lookup[_Gas Export Daily Data]=1) Then (again) after conversion to boe (multiply with 0.0062897) and add Net share oil (this measure uses a similar logic), I show a cumulative graph of this measure using the same measure as above; Net Cumulative Sales = CALCULATE([Total Net share Sales boe],DATESYTD(Rolling_Calendar[Date])) When working in Desktop, all looks fine and works, but when publishing to Power BI service I get the following error: "This visual has exceeded the available resources. Try filtering to decrease the amount of data displayed. Please try again later or contact support. If you contact support, please provide these details." After researching the forum and the internet, I've tried to solution to show fewer datapoints and it works if I show my data until August 1st or select less assets, but this is not the required solution as I want to show the entire year of data. Another solution was to rewrite the measures and using variables, but this didn't help me so far. Any ideas are highly welcome as it's quite a cumbersome trial and error process as you don't see the error after you've published it. Thanks in advance! Gerlof EDIT: As the report needs to function for my users, I have decided to publish the old measures again, but now I get the same error message. EDIT2: I didn't fully set the measures back, so now it's working again. Would it help if I decrease the entire dataset? Or doesn't that affect this issue?
Solved
5 years ago Place Service
Need Help
1.6KViews
0likes
2Comments
Re: Promedio de medida
Hola Creo que tengo un problema similar. ¿Cuál fue la mejor solución? saludos
5 years ago Place Translated Spanish Desktop
2.9KViews
0likes
0Comments
Re: Totales de función divde
Gracias a todos, No se resuelve como quería, pero me estimulaste a pensar en diferentes soluciones.
5 years ago Place Translated Spanish Desktop
919Views
0likes
0Comments
Re: Totals of divde function
Thanks all, It isn't solved as I wanted, but you did stimulate me to think of different solutions.
5 years ago Place Desktop
2.1KViews
0likes
0Comments
Re: Totales de función divde
Hola @yingyinr / @amitchandak , Gracias por tus pensamientos. He mencionado para obtener los valores correctos, mediante el uso de la dax calculado. Better Potential = sumx(CALCULATETABLE(flow_data_forecast,Rolling_Calendar[Year]),[Total Potential boe]) Y también he ajustado la medida Total Potential: Total Potential boe = [Total Gross Budget boe]/[Uptime Correction] Aunque no estoy seguro de si este es el mejor enfoque, porque parece tomar bastante potencia informática. Estaba buscando en línea en pros / contras para el uso de este dax, pero realmente no los he visto todavía. ¿Tienes algún consejo? saludos Gerlof
5 years ago Place Translated Spanish Desktop
921Views
0likes
2Comments
Re: Totals of divde function
Hi Anonymous / amitchandak , Thanks for your thoughts. I have mentioned to get the correct values, by using the calculatedtable dax. Better Potential = sumx(CALCULATETABLE(flow_data_forecast,Rolling_Calendar[Year]),[Total Potential boe]) And I have also adjusted the Total Potential measure: Total Potential boe = [Total Gross Budget boe]/[Uptime Correction] Although I am not sure if this is the best approach, because it seems to take quite some computing power. I was looking online on pros/cons for using this dax, but haven't really seen them yet. Do you have any advise? Regards, Gerlof
5 years ago Place Desktop
2.1KViews
0likes
2Comments
Totales de función divde
Hola Estoy tratando de resumir después de un cálculo de división basado en el filtro "facility_id". He visto algunas soluciones usando HASONEFILTER y se siente como si estuviera llegando allí, pero todavía no del todo. En este momento estoy tratando de evaluar el potencial a nivel de instalaciones y esto funciona. Pero al resumirlo, el total está mal, ya que se divide en el nivel de fila. Esta es mi tabla de datos que es correcta en un nivel de fila: Mis medidas son: Total Potential boe = [Total Gross Budget boe]/[Uptime Correction] Uptime Correction = CALCULATE(AVERAGE(Facility_Lookup[_Uptime]),Facility_Lookup[Facility_ID]) Total Gross Budget boe = [100% Budget Gas boe]+[100% Budget Oil] 100% Budget Oil = CALCULATE(sum('flow_data_forecast'[FL_DATA_NET_VOL]), 'flow_data_forecast'[FORECAST_ID]=1,flowID_Lookup[_Oil Sales Daily Data]=1) 100% Budget Gas boe = [100% Budget Gas Nm3]*0.0062897 100% Budget Gas Nm3 = CALCULATE(sum('flow_data_forecast'[FL_DATA_NET_VOL]), 'flow_data_forecast'[FORECAST_ID]=1,flowID_Lookup[_Gas Sales Daily Data]=1) Así que cualquier ayuda es apreciada. saludos Gerlof
Solved
5 years ago Place Translated Spanish Desktop
987Views
0likes
7Comments
Totals of divde function
Hi, I am trying to sum up after a division calculation based on the "facility_id" filter. I have seen some solutions using HASONEFILTER and it feels like I'm getting there, but still not quite. At the moment I'm trying to assess the potential on a facility level and this works. But then when summing it up, the total is wrong as it divides on row level. This is my data table which is correct on a row level: My measures are: Total Potential boe = [Total Gross Budget boe]/[Uptime Correction] Uptime Correction = CALCULATE(AVERAGE(Facility_Lookup[_Uptime]),Facility_Lookup[Facility_ID]) Total Gross Budget boe = [100% Budget Gas boe]+[100% Budget Oil] 100% Budget Oil = CALCULATE(sum('flow_data_forecast'[FL_DATA_NET_VOL]), 'flow_data_forecast'[FORECAST_ID]=1,flowID_Lookup[_Oil Sales Daily Data]=1) 100% Budget Gas boe = [100% Budget Gas Nm3]*0.0062897 100% Budget Gas Nm3 = CALCULATE(sum('flow_data_forecast'[FL_DATA_NET_VOL]), 'flow_data_forecast'[FORECAST_ID]=1,flowID_Lookup[_Gas Sales Daily Data]=1) So any help is appreciated. Regards, Gerlof
Solved
5 years ago Place Desktop
Need Help
2.3KViews
0likes
6Comments
Re: Totales de función divde
Hola @amitchandak , Gracias, que ayudará con mis más preguntas, pero tienes razón, esto no fue un problema de sumx. Me di cuenta de que también hay un error al resumir mi "Potencial total", la suma real de esta columna 84,771,290.7 (después de exportar a Excel).
5 years ago Place Translated Spanish Desktop
960Views
0likes
5Comments

Data Privacy

Microsoft Fabric Community and Privacy

To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.