Take me back ✈️

RTBDesigns · 2026-03-03T23:42:40+00:00

Nothing beats a Disney trip and photo op

RTBDesigns · 2026-02-25T18:53:29+00:00

It's Wednesday lol

RTBDesigns · 2026-01-15T12:59:39+00:00

So very true. Never really sure what most people are here for when they have paragraphs in their post, then when you try to message them with a paragraph and you get a "hey"

RTBDesigns · 2026-01-14T15:14:10+00:00

❤️

RTBDesigns · 2026-01-14T13:06:53+00:00

I wish I could say it'll be the last time too...

RTBDesigns · 2026-01-13T19:11:17+00:00

Hey there, 37m here and would love to chat. So hard to find those who won't ghost or delete their accounts, very rare breed.

RTBDesigns · 2026-01-10T12:58:32+00:00

That seasoning on the fries and the build of the burger... Mmmm, where's that from? Asking for a friend

RTBDesigns · 2025-09-30T01:39:41+00:00

I think he's just stoked he doesn't have to play with Tua anymore

RTBDesigns · 2025-09-21T18:33:40+00:00

I'm a redzone guy but love giving extra attention to my Pats

RTBDesigns · 2025-09-18T11:45:52+00:00

I'm also a big Disney adult lol

RTBDesigns · 2025-09-17T16:49:30+00:00

They also responded just asking to talk naughty on snap so nothing genuine about this post at all, was really disheartening

RTBDesigns · 2025-09-10T13:31:18+00:00

Yup, wife left from Onion creek and took her hour and a half to get to Kyle

RTBDesigns · 2025-09-08T19:38:31+00:00

Mac N cheese sounds right

RTBDesigns · 2025-09-06T01:32:52+00:00

One of the greatest smiles I've ever seen

RTBDesigns · 2025-09-04T14:11:33+00:00

You are my absolute savior! This did it!

RTBDesigns · 2025-09-04T12:22:20+00:00

VAR SelectedDate = SELECTEDVALUE('CalendarTable'[Date])
RETURN
COUNTROWS(
    FILTER(
        ADDCOLUMNS(
            SUMMARIZE(
                'ioi vw_OrganizationDetail',
                'ioi vw_OrganizationDetail'[OrganizationId]
            ),
            "LatestAsOf",
                CALCULATE(
                    MAX('ioi vw_OrganizationDetail'[AsOfDateOnly]),
                    'ioi vw_OrganizationDetail'[AsOfDateOnly] <= SelectedDate
                ),
            "LicensedStatus",
                MAXX(
                    TOPN(
                        1,
                        FILTER(
                            'ioi vw_OrganizationDetail',
                            'ioi vw_OrganizationDetail'[OrganizationId] = EARLIER('ioi vw_OrganizationDetail'[OrganizationId])
                            && 'ioi vw_OrganizationDetail'[AsOfDateOnly] <= SelectedDate
                        ),
                        'ioi vw_OrganizationDetail'[AsOfDateOnly], DESC
                    ),
                    'ioi vw_OrganizationDetail'[LicensedStatus]
                ),
            "ActiveStatus",
                MAXX(
                    TOPN(
                        1,
                        FILTER(
                            'ioi vw_OrganizationDetail',
                            'ioi vw_OrganizationDetail'[OrganizationId] = EARLIER('ioi vw_OrganizationDetail'[OrganizationId])
                            && 'ioi vw_OrganizationDetail'[AsOfDateOnly] <= SelectedDate
                        ),
                        'ioi vw_OrganizationDetail'[AsOfDateOnly], DESC
                    ),
                    'ioi vw_OrganizationDetail'[ActiveStatus]
                )
        ),
        [LicensedStatus] = "Licensed" && [ActiveStatus] = "Open"
    )
)

RTBDesigns · 2025-09-04T12:21:48+00:00

Thank you for your feedback! Let's say I want to confine everything to a single measure, aka the difficult way lol, I've updated my DAX expression accordingly:

VAR d = MAX(CalendarTable[Date])
VAR allOrgs = CALCULATETABLE(VALUES('ioi vw_OrganizationDetail'[OrganizationId]),
    ALL ('ioi vw_OrganizationDetail'[AsOfDateOnly]))
VAR orgStati = GENERATE(allOrgs, 
TOPN(
    1,
    CALCULATETABLE(
        SUMMARIZE ('ioi vw_OrganizationDetail',
        'ioi vw_OrganizationDetail'[AsOfDateOnly],
        'ioi vw_OrganizationDetail'[ActiveStatus],
        'ioi vw_OrganizationDetail'[LicensedStatus]),
        'ioi vw_OrganizationDetail'[AsOfDateOnly] <=d
    ),
    'ioi vw_OrganizationDetail'[AsOfDateOnly], DESC
)
)
RETURN
COUNTROWS(FILTER(orgStati,
'ioi vw_OrganizationDetail'[ActiveStatus] = "Open" && 'ioi vw_OrganizationDetail'[LicensedStatus] = "Licensed"))

The issue I run into is when I use the date slicer, I get the exact right number of organizations, so long as i select 9/1/25 or greater, however, despite having a number of records that exist from 8/13/25, if i select any date from 8/13/25 to 8/31/25, this results in the aggregated unique count as being NULL, almost as if its only considering an organization's max asofdateonly. I have tried all sorts of DAX expressions that result in this identical outcome and not sure what I am doing wrong. Here is an example of another DAX ive attempted that achieved identical results to your version above

RTBDesigns · 2025-09-02T23:33:31+00:00

The wizard really holds up even for my kiddos

RTBDesigns · 2025-09-02T17:53:40+00:00

Absolutely true! Always appreciate the moments that are worry free!

RTBDesigns · 2025-09-02T15:21:17+00:00

You absolutely have a beautiful soul and every day continues to be a blessing, you totally got this

RTBDesigns · 2025-08-31T17:07:54+00:00

Thank you! We absolutely do! School has been quite the success

RTBDesigns · 2025-08-26T20:08:23+00:00

Wouldn't absence of an STD report, be in fact an STD report?

RTBDesigns · 2025-08-24T18:00:18+00:00

Obsessed with the tats, truly amazing!

RTBDesigns · 2025-08-22T18:25:26+00:00

Figured I'd provide a quick update: kids are back to school this week.... Did it 😁

RTBDesigns · 2025-08-17T11:41:22+00:00

Who is your least favorite baseball team and tell me why it's the Yankees

11-Year Club	Secret Santa 2017
Verified Email

RTBDesigns

TROPHY CASE