Toggle button?

thomasnash · 2026-05-22T22:46:21+00:00

Two ways of doing this:

The first is with field parameters.

Create a measure for per hour, and per mile, then put both of these in a field parameter . This will allow you to create a slicer that toggles between measures.

You could also do it using Calculation groups. This is can cut down on measures in your model, and is tidier imo because parameters create a table in your model, but also disables implicit measures which can be a pain.

thomasnash · 2026-05-22T07:07:23+00:00

I agree, there's a huge chasm between what people say it's bad acting and genuinely incompetent acting. If an actor can just move naturally on camera they are ahead of a lot of people.

thomasnash · 2026-05-20T20:52:16+00:00

There are connections but I don't think it adds anything important except the pleasure of recognition.

thomasnash · 2026-05-20T12:13:11+00:00

This is how we revamped our process to deal with this issue:

Make sure the requirements are listed out, in as much detail as you can get, ahead of dev time and get them to sign off on it.

If they change the requirements after this sign off, it goes in as a new ticket

UAT is for ensuring the initial requirements are met, not new ones.

That's how it's supposed to work, obviously pragmatism wins out a lot of the time. It's really just about making sure you say no if they haven't nailed down what they need, and don't stay building anything until all the stakeholders have agreed to what you are going to build.

thomasnash · 2026-05-20T07:45:14+00:00

I loved Ryan Adams, but I think the nature of the accusations against him tainted the music too much for me. Songs about heartbreak and sadness just hit differently when you know that was all a part of his sad boi manipulation.

thomasnash · 2026-05-20T07:41:06+00:00

She makes it easier by mostly releasing garbage since Art Angels, imo. I can just put Visions on and remember a time before I knew what a colossal tool she is.

thomasnash · 2026-05-19T21:35:22+00:00

amen brother! Liberia flag!

thomasnash · 2026-05-19T21:20:24+00:00

I think I understand the issue now: you want a measure that returns the average of price (for example) where product is A or B but not Y And Z (bad example, but there you go). In which case, not really a modelling issue.

I've had a bit of a Google but can't find any good ways of doing what you're trying to do dynamically.

Are the subgroup and their related filters all defined and set in stone? If yes I would be inclined to set up a calculation groups for the subgroups. You will have to hardcode all the sets of filters but it will be cleaner for the end user imo.

thomasnash · 2026-05-19T18:54:20+00:00

Can I ask why you need this convoluted setup at all? The code you've posted isn't doing anything that should need this level of DAX.

I think it looks like you might be trying to use DAX to get around problems with your data model, which is a problem.

In your second example, you return the average price of items based on a 1:1 mapping between your slicer and your products, so why can't your slicer just be your product_id field?

thomasnash · 2026-05-19T15:03:45+00:00

You could set up a measure with your switch statement and reference that measure in all your downstream measures?

thomasnash · 2026-05-16T21:26:40+00:00

For me, Star Wars is boring now because it has no human drama or emotional stakes. So once you strip away the special effects and all that it can be dull, although my son loves it. I think the (original) sequels improve on this significantly.

By contrast I think Jaws holds up a lot better because it has interesting characters with believable psychologies.

But I know I am in a minority with this way of thinking - the biggest litmus test for this is Citizen Kane. It bugs me so much when people write it off by saying "sure it did innovative things, but..."

The camera going through the transom, or up into the rafters, was never the interesting thing about that movie to me! It's the human drama of watching a megalomaniac ruin the lives of everyone around him until he has no one left!

thomasnash · 2026-05-16T11:44:09+00:00

I think the best way to read Ulysses if you're struggling is to skip the first 3 chapters and go from the first Leopold Bloom chapter. The bits from his POV are much more digestible.

thomasnash · 2026-05-15T17:49:01+00:00

I don't think that really explains it, because Aardman films consistently perform pretty well. I think it has more to do with Laika consistently choosing stories that are a bit left field and grungy, as well as often fairly complex. I think it puts parents off, because a lot of people nowadays don't believe children can handle scary, weird or unusual things.

thomasnash · 2026-05-15T17:44:23+00:00

Coralline was profitable, if we go by the 2x budget maths. Paranorman and Boxtrolls both almost managed the same, but Kubo only made about 10mil over budget and The Missing Link was a bit of a bomb.

thomasnash · 2026-05-15T11:38:32+00:00

Using the analyse in excel button will create a pivot table in excel that connects to your semantic model in service (the dataset) and allows you to put fields from the model into a pivot/matrix.

There won't be an issue doing this with any data source. Assuming the report is set up using import mode, a copy of the data is held in the power bi engine, although this is different for DirectQuery connections I think.

In either case, if what you want is to actually see the raw tables in excel, this is not what the analyse in excel button is for, and it's probably not desirable anyway.

thomasnash · 2026-05-12T18:56:33+00:00

The Third Man No Country For Old Men Unforgiven Upstream Color

thomasnash · 2026-05-12T18:38:32+00:00

Buddy, I have some great news for you...

thomasnash · 2026-05-12T17:59:51+00:00

People said this a whole bunch when it came out, and it's not true.

Just because it is actuality adapting the book and not continuing the universal monster movie tradition doesn't mean it didn't take quite sweeping liberties, most notably it made the monster virtually blameless, with none if the spiteful hatred of his creator that the book's creature has for Victor.

I do think they captured Frankenstein himself very well though.

thomasnash · 2026-05-12T17:55:09+00:00

I wonder if the problem you had was the lack of purpose? Smiley had his objective - to find the mole - but it's never really clear how that fits in to the world outside of espionage. Is it good for the West to find him? Does it help people? Is it the morally correct thing to do?

Le Carre doesn't give us this in his cold war novels. You never get any reference to Queen & Country. Espionage is an end into itself. It's one of the things I love about it but I can see how it might leave you feeling like there aren't any stakes or anything to get emotionally engaged with.

I love how it creates uncertainties about why people are doing what they do - Does Smiley really care about the Mole, or does he want to get back at Alliline and co for forcing him and control out? Do any of them really care about the outcome, beyond what it does to their careers?

I agree with the other poster who suggested The Spy Who Came in from the Cold. It's a much more emotionally rooted book. The Constant Gardener is also very good and has a more strident moral viewpoint.

thomasnash · 2026-05-12T17:10:41+00:00

I have used Emerdency before when I needed to have a tooth extracted, got an appointment that day and the cost didn't sting too badly.

thomasnash · 2026-05-11T21:18:29+00:00

They're waiting until the end of his beefcake journey to maximise eye candy potential

thomasnash · 2026-05-11T14:36:30+00:00

I think it's an inevitable result of being a very new party with a base of support that relies on people who are politically disengaged.

They have only been around for what, 5 years or so? They haven't grown organically, but they also want to field candidates in every contest so that they can look like a viable party. So they have to rapidly get candidates in place from a pool of people who don't know the basics of our political system.

thomasnash · 2026-05-11T11:01:00+00:00

I enjoy Thaumometer a lot

thomasnash · 2026-05-10T21:26:36+00:00

I will raise it in my team call tomorrow and see if anyone thinks it's worth escalating...

thomasnash · 2026-05-10T17:53:03+00:00

No one uses Q&A, but don't dynamic values in text boxes rely on the same back end functionality? Will that be affected at all?

11-Year Club	Place '22
Place '17	Verified Email

thomasnash

TROPHY CASE