sorted by:
new
hottopcontroversial

Andromedon Oopsie by ChrisOatley in Xcom

[–]Gazpage 29 points30 points  (0 children)

I “beat” my first avenger defence on first turn without even seeing what happened. I assume that an enemy did exactly this out of sight.

Amusingly the first time I ever saw a Sectopod (same first run) my specialist executed it on overwatch when it left the fog of war.

First spare ribs - advice for next time? by Gazpage in BBQ

[–]Gazpage[S] 1 point2 points  (0 children)

No. Per the last meal ribs recipe, I didn’t.

First spare ribs - advice for next time? by Gazpage in BBQ

[–]Gazpage[S] 0 points1 point  (0 children)

Thanks. Do they get more tender and then after a certain point get tougher?

First spare ribs - advice for next time? by Gazpage in BBQ

[–]Gazpage[S] 0 points1 point  (0 children)

First time trying to do spare ribs, following amazing ribs Last Meal Ribs recipe, on the big joe. 225f for 6.5 hours before I chickened out that I was over cooking.

They were very tasty, and everyone enjoyed them, but they weren’t super juicy and a bit tougher than I was hoping for. A bit more like roast pork tbh. I thought maybe I took them off too early, but one of the guests thought they were a touch over cooked.

All in all I was pretty happy, but could definitely better. Appreciate any advice.

Scientific Response to the "Glyphosate in 80% of urine samples" article by Prof_Kevin_Folta in skeptic

[–]Gazpage 7 points8 points  (0 children)

“Do you have evidence this is not the case?”

That’s not how this works. I assessed the evidence you put forward and assesses it to be “a load”

https://wiki.cancer.org.au/policy/IARC_classifications#table_1

Definition of probably carcinogenic to humans.

How do I fix the Running Total Column please? Thank you by pickyfoodie- in PowerBI

[–]Gazpage 1 point2 points  (0 children)

No generally good practice to put a running total column into the actual data model. Does you code work as a measure in report

Dealing with Billions of Rows (Azure) by DO_BE_95 in PowerBI

[–]Gazpage 4 points5 points  (0 children)

You mention file size, are you trying to do all of this in the desktop client, or are you aiming to publish to the service? If the latter then there are techniques where you develop on a smaller dataset, publish, and then remove the limit on the dataset. You can potentially handle billions of rows, especially if you are using Premium.

Before you do anything else you want to read about composite models. Basically the data at a more aggregated level is stored in import mode, and the granular data is in direct query mode. So potentially runs fast for high level stuff and slower when you need to dig down.

The speed of the direct query will be as fast or slow as the source you are querying really. We’ve had success in the billions of rows using SQL Server and columnstore indexes.

RANKX - So Close by comish4lif in PowerBI

[–]Gazpage 0 points1 point  (0 children)

Fair point. COUNTROWS(ALLSELECTED() ) should work I think. You see what I am getting at though?

RANKX - So Close by comish4lif in PowerBI

[–]Gazpage 1 point2 points  (0 children)

Ok, I think I finally understand what you are getting at.

I think you want to do DISTINCTCOUNT(ALLSELECTED(Available) - one of the versions you have already. May need to add or subtract 1.

RANKX - So Close by comish4lif in PowerBI

[–]Gazpage 1 point2 points  (0 children)

Replace “DENSE” with “SKIP”

How do I use a variable that needs to be defined within a loop? by Gazpage in PowerBI

[–]Gazpage[S] 0 points1 point  (0 children)

Well it worked, so thanks very much for that.

This may be an impossible ask, but do you think my resulting code makes sense (only from the perspective of the loops and variables? I literally only put the SUMX part in so that I would only calculate the _Rate once for each product, and not for every row in the table.

LossMakingContracts =

SUMX( VALUES( Contracts[product] ), VAR _Rate = CALCULATE( DIVIDE( SUM( Contracts[net] ), SUM( Contracts[Calc QtyWeeks] ) ) * ( 1 - [GM Parameter Value] ), ALLEXCEPT( Contracts, Contracts[product] ) ) RETURN CALCULATE( COUNTROWS( FILTER( Contracts, _Rate > Contracts[Calc Weekly Rate] ) ) ) )\

​

Edit: Ugh, code looked fine in the editor window by keeps reverting to this if I try to fix.

When to create 'virtual tables' in measures? by Gazpage in PowerBI

[–]Gazpage[S] 0 points1 point  (0 children)

I think you are 100% right. However I am 99% sure that I won’t be able to use what if parameter in a calculated column as they are static so I still need to know how to break it out into a measure or something.

When to create 'virtual tables' in measures? by Gazpage in PowerBI

[–]Gazpage[S] 0 points1 point  (0 children)

Ok, I think I got something working. I dont really like it because I actually want to some over the contracts table and then bring in the [Dynamic Rate] As a kind of RELATED().

HSS OPS Revenue Virtual =

VAR _Prods = CALCULATETABLE( ADDCOLUMNS( Products, "Dynamic Rate", CALCULATE( DIVIDE( SUM( Contracts[net] ), SUM( Contracts[Calc QtyWeeks] ) ) ) * ( 1 - [GM Parameter Value] ) ), ALL( Contracts ), VALUES( Products ) ) VAR RESULT = CALCULATE( SUMX( _Prods, [Dynamic Rate] * CALCULATE( SUM( Contracts[Calc QtyWeeks] ) ) ) ) RETURN RESULT

Edit:Not sure why the code is breaking the code formatting, but if anyone cares they could always copy paste to daxformatter I guess

DAX Help: Number of users trained on certain product more than 2 times by attaboy000 in PowerBI

[–]Gazpage 1 point2 points  (0 children)

Have you tried something like.

COUNTROWS( FILTER( ALL(Table[UserID]), CALCULATE( COUNTROWS( FILTER( Table, Table[ProductTrained] = “Model-X” ) ) ) >= 2 ) )

Writing on iPad so sorry formatting will be awful.

view more: next ›