u/JosVermeulen

48.0k post karma · 50.8k comment karma · joined Aug 2013 · moderator

  1. 5points

    Totals gone from tables (self.PowerBI) [Question]

    7 comments

  2. 5points

    Capped Exp. Share gives 1 Exp. Points to all party pokemon (self.PokemonUnbound) [Help]

    8 comments

  3. 6points

    Deployment pipelines - Shows changes where there are none (self.PowerBI) [Question]

    5 comments

  4. 9points

    No automatic or manual lane change on '25 Premium with BlueCruise (self.MachE) [ ❓Question ]

    14 comments

  5. 6points

    User context aware calculated columns can't be used with SELECTEDVALUE (self.PowerBI) [Question]

    12 comments

JosVermeulen

Of course.. but that's what I'm saying. Fixing in desktop and then publishing doesn't fix it in service.

JosVermeulen

That's the thing. Republishing didn't work. It actually had to be fixed in the service.

JosVermeulen

Morphe instead of Revanced nowadays I'd say.

JosVermeulen

Sponsorblock is exactly that. It is community-driven and has segments of videos tagged as ads, etc. Revanced has Sponsorblock built-in, though nowadays Morphe is the better option.

JosVermeulen

Toevallig net zijn biografie aan het lezen. Zou enkel de moordenaars van zijn (zwarte) oom zo genoemd hebben.

JosVermeulen

I think I found my issue. I thought the level cap the gym leaders mentioned was the real cap. So trying to get there I removed capped exp share and my hariyama got 46 that way. But I realize now that the actual cap is different from the obey cap.

JosVermeulen

I think I found my issue. I thought the level cap the gym leaders mentioned was the real cap. So trying to get there I removed capped exp share and my hariyama got 46 that way. But I realize now that the actual cap is different from the obey cap.

JosVermeulen

Level 45 to 39. Then it works again, strangely enough. I haven't done any cheats, so I'm baffled. I'm at Tarmigan Town in the Tarmigan Mansion.

JosVermeulen

Just tried it, but sadly enough didn't fix the issue.

JosVermeulen

I noticed most charts don't seem to start from zero or they aren't proportionate to the data.

JosVermeulen

I just found this post and it looks very promising, but it looks like this doesn't work for unused objects when the dataset exists in another workspace than the reports?

JosVermeulen

An even faster way to turn it off is to disable this in your profile (it will still activate every start) and then you can just reload your profile with the number on the door and it's gone.

JosVermeulen
JosVermeulen

I hate it as well. I just go via the onelake catalog now.

JosVermeulen

Is it normal that you can't use SELECTEDVALUE on a user-context-aware calculated column ?

JosVermeulen

I'm talking about using SELECTEDVALUE (of course in a measure) on a column generated by the new user context aware calculated columns.

JosVermeulen

I just did SELECTEDVALUE as a test to use later and that already failed.

JosVermeulen

I can do HASONEVALUE, but FIRSTNONBLANK still gives the same error for me.

JosVermeulen

It's basically just this:

MaskedAttribute =
VAR _UserIdentifier =
    [UserIdentifier]

VAR _CurrentUser =
    USERPRINCIPALNAME ()

VAR _AccessGranted =
    LOOKUPVALUE (
        SecurityTable[AuthorizedUser],
        SecurityTable[AuthorizedUser], _UserIdentifier
    )

RETURN
    IF (
        _UserIdentifier = _CurrentUser || _AccessGranted = _UserIdentifier,
        [VisibleAttribute],
        "Masked"
    )

And the SecurityTable is filtered through RLS.

JosVermeulen

MAX gives the same error.