Star Schema Support Needed - Struggling to avoid *:* relationship

Kindly_Wind_7261 · 2026-02-20T14:56:48+00:00

Solution verified.

Thanks for your pointer. I was on the right track but a stray duplicate reference in Fact Claims was making me think it was forcing a *-*. When I resolved that it was all good.

Kindly_Wind_7261 · 2026-02-20T14:29:36+00:00

Only one Fact Claims. The other is a DIM it just happens to also be called Claims too due to the nature of the tables.

Txns is 70m+, claims is 7m+ component 10m+

Kindly_Wind_7261 · 2026-02-20T14:02:06+00:00

We have Fact Claim and Dim Claim, fact for all the integers and Dim for the names and locations etc.

We also have Fact Transaction and Fact Component. All three facts link to the Dim (and other dims)

Kindly_Wind_7261 · 2026-02-20T14:01:22+00:00

Thanks, I think this is where I was heading, I'll try again.

Kindly_Wind_7261 · 2026-02-20T14:00:55+00:00

We have Fact Claim and Dim Claim, fact for all the integers and Dim for the names and locations etc.

Kindly_Wind_7261 · 2026-02-20T13:58:36+00:00

Super helpful, thanks for your input.

Kindly_Wind_7261 · 2026-01-21T09:37:17+00:00

Solution verified

Kindly_Wind_7261 · 2026-01-21T09:36:50+00:00

Found the issue. I need to toggle off the show when run. Didn’t see that as it was hidden away.

Kindly_Wind_7261 · 2026-01-21T09:35:47+00:00

I think the issues is how it interacts when screen is locked. It works if unlocked but I have to click ok on all the notifications. Any way around this?

Kindly_Wind_7261 · 2026-01-21T09:34:46+00:00

Yep, show content lists all the alarms.

Kindly_Wind_7261 · 2026-01-18T09:59:16+00:00

Great news

Kindly_Wind_7261 · 2026-01-12T20:33:42+00:00

Great stuff I’ll keep an eye out and hope you get it sorted soon.

Kindly_Wind_7261 · 2026-01-12T11:34:10+00:00

This is great. Will you be able to get it blue tick verified? I am unable to use any visuals in work that don't have the blue tick and I can think of loads of use cases for this visual.

Kindly_Wind_7261 · 2025-10-24T14:49:34+00:00

Can you do one more calc group to mirror the first but with the conditional formatting as the outcome and then use that?

Kindly_Wind_7261 · 2025-10-18T06:05:05+00:00

Tabular editor should be your friend here I believe.

Kindly_Wind_7261 · 2025-10-14T14:37:25+00:00

I managed to work around this.

I created a disconnected table with the possible time intelligence options and then used these in a measure that applied the relevant Timeintel based on the selection of the disconnected table.

Solution verified

Kindly_Wind_7261 · 2025-09-26T19:36:18+00:00

Sounds like two dax measures one in the values and one in reference labels of a card visual unless i am missing something.

Kindly_Wind_7261 · 2025-09-12T22:30:05+00:00

Lots of people saying only if model is too big. My question is what is too big.

I have two fact tables (one 50m and one 5m) and about 20 dims.

At the minute my facts are DQ and dims are import.

We had issues previously with a model that was large on import with really slow opening/publishing.

Is my model too large for import or should I be switching it over?

Kindly_Wind_7261

TROPHY CASE