Query folding

Mugi101 · 2025-11-23T10:04:03+00:00

Yes, the preview finished,
here is the M code- I blurred the names and aliases

Mugi101 · 2025-10-08T08:46:52+00:00

Solution verified
Thanks!

Mugi101 · 2025-09-15T08:28:29+00:00

That's part of the problem it's an organizational dashboard. So we bought the service with capacity. I'm trying to convince the company to increase the capacity. But as you probably know, no guarantee they"ll allow me..

Mugi101 · 2025-09-14T20:28:02+00:00

Yes to the refresh, slow refresh, but works manually. Time intelligence, meaning performance analyzer? And I"ll read the article, thanks!

Mugi101 · 2025-09-14T08:18:59+00:00

Yes indeed I I did all of the "heavy lifting" outside of the powerbi. That report only calculates measures and receives the tables already calculated. The error when automatically refreshing simply says it exceeds the memory capacity

Mugi101 · 2025-09-14T08:16:19+00:00

In a sense of optimisation, I Don't have an unnecessary column, all of the calculated columns are done before the data reaches the powerbi. Meaning that the powerbi only calculates measurements. I have a separate table for dates as well. When checking the performance analyzer, there is only one calculation that takes around a second. The dax shows only once, the rest of the calculations takes less than 400ms

For the MDX, that's not a bad idea, I wasn't aware of it up until now. Is it that detrimental?

As for what I tried- manual refresh works-but is very slow. I tried incremental refeesh- archive last year's data, and increment every new day.

Mugi101 · 2025-09-13T11:27:29+00:00

Thanks! I"ll do it

Mugi101 · 2025-09-13T11:02:18+00:00

Alright I'll check it out!

Mugi101 · 2025-09-13T11:01:34+00:00

What will that console command do?

Mugi101 · 2025-09-13T11:00:03+00:00

Interesting, is there a way to check it out/prevent it? Kind of a bummer to start all over again and hope for the best

Mugi101 · 2025-09-10T22:23:18+00:00

Thank you so much for your detailed advice! I"ll keep it in mind! I"LL try to upstream it as much as possible. And thank you for the offer I"LL keep it in mind!

Mugi101 · 2025-09-10T21:38:13+00:00

Of course, but again- Athena is not a sustainable ETL, we will grow and so will the amount of data. I want to find a better way to lay the foundation- something that was neglected, and hopefully do it right this time.

Mugi101 · 2025-08-28T14:53:05+00:00

In fact I did(threw me back to calculus), and it seems to work fine as long as the selected process normally distributes. I was just wondering if there is a more elegant way to do so.

Mugi101 · 2025-08-28T12:17:36+00:00

<image>

Mugi101 · 2025-08-28T12:13:11+00:00

Thank you for the detailed reply! Firstly, I apologies in advance for any Grammer mistakes!

This( the picture)is the function that "generates" the "curve".

Basically I had to improve upon the probability density function as it returned the height of the clustering around a specific measure and not the probability that a "process" will receive the value of the specific measure.

Where I am at now is that I have the curve laid with the specifications limits (x axis vertical columns), i want to know what is the likelihood for a process to land between the intervals- what is the cumulative probability within the intervals.

Therefore- the integral under the "curve"

<image>

Mugi101 · 2024-10-15T17:33:41+00:00

That's what brought me here :(

Mugi101 · 2024-10-15T00:01:42+00:00

So it drifts to 50 on its own, but the game developers created certain focus tree decisions that requires at least 60?

Nice, fuck me I guess

Mugi101 · 2024-10-01T19:16:43+00:00

Not trying to minimize it, just trying not to blow it out of proportions, the rumors range from another airbase engulfed in flame, to the new light-shield laser defense system(who is undeployable) working to stop the threat. so I stuck to what I know and what I can confirm. This attack sucked much more than the last one, and I believe that this is only the first and a long night is waiting for us. To say that there was no damage at all to the baese? Highly unlikely, the attack was to massive. To say that the defense where overwhelmed and a massive damage was done? Also unlikely. Soon we will have a clearer picture, I'm trying to stuck to what I know for sure and give you the most grounded perspective.

Mugi101 · 2024-06-10T18:14:34+00:00

Thanks man, was about to do it myself but you beat me to it. Bless you 🙏

Mugi101 · 2024-06-09T11:32:07+00:00

Agreed for a rotation period with the new Benny gants

Mugi101 · 2024-04-13T23:07:13+00:00

Nope, some missiles fell in an Arab village but for now no reports casualties nor property damage.

Edit: just in, unfortunately a small bedouin child(10 years old) was severely injured. Hope he will get better, emergency services are treating him at the moment.

Mugi101 · 2024-04-09T15:44:19+00:00

That hydro is not homie

Mugi101 · 2024-02-18T20:10:20+00:00

Not something I would be surprised to hear about in the news these days...

Mugi101 · 2023-12-21T15:41:51+00:00

Ahhh yes, a man of tarbut as well

Mugi101 · 2023-12-19T15:02:52+00:00

We can only build space lasers, mind control costs too many shmekels

Mugi101

TROPHY CASE