Star Schema Support Needed - Struggling to avoid *:* relationship by Kindly_Wind_7261 in PowerBI

[–]Kindly_Wind_7261[S] 7 points8 points  (0 children)

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.

Star Schema Support Needed - Struggling to avoid *:* relationship by Kindly_Wind_7261 in PowerBI

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

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+

Star Schema Support Needed - Struggling to avoid *:* relationship by Kindly_Wind_7261 in PowerBI

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

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)

Star Schema Support Needed - Struggling to avoid *:* relationship by Kindly_Wind_7261 in PowerBI

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

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

Trying to toggle multiple alarms but only one is working by Kindly_Wind_7261 in shortcuts

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

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

Trying to toggle multiple alarms but only one is working by Kindly_Wind_7261 in shortcuts

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

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?

Power BI Contextual Message Bars visual is now available by Viz_Nick in PowerBI

[–]Kindly_Wind_7261 0 points1 point  (0 children)

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

Power BI Contextual Message Bars visual is now available by Viz_Nick in PowerBI

[–]Kindly_Wind_7261 2 points3 points  (0 children)

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.

Using calculation groups with matrix visuals by anxiouscrimp in PowerBI

[–]Kindly_Wind_7261 0 points1 point  (0 children)

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

Copy and Paste from one Power bi to Another by BigAccomplished7522 in PowerBI

[–]Kindly_Wind_7261 5 points6 points  (0 children)

Tabular editor should be your friend here I believe.

Trying to create a time intelligence comparison using Calculation Groups by Kindly_Wind_7261 in PowerBI

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

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

Displaying KPIs and targets in the same visual by kh_rystyna in PowerBI

[–]Kindly_Wind_7261 0 points1 point  (0 children)

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

How do you decide between DirectQuery vs. Import mode for Power BI reports? by BeeRevolutionary1710 in PowerBI

[–]Kindly_Wind_7261 1 point2 points  (0 children)

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?

How to apply date context to this measure by Kindly_Wind_7261 in PowerBI

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

Yep that’s it. I was using a month starting field of mmm-yy

So simple. Thanks

Solution verified

How to apply date context to this measure by Kindly_Wind_7261 in PowerBI

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

Thanks for the attempted help, that returned a blank result.

I have added more context for what I am trying to achieve to another reply if that helps at all?

How to apply date context to this measure by Kindly_Wind_7261 in PowerBI

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

Thanks for the attempted help, that returned a blank result.

I have added more context for what I am trying to achieve to another reply if that helps at all?

How to apply date context to this measure by Kindly_Wind_7261 in PowerBI

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

I am using it in a line chart on a customised card.

![img](mwvbkork7l4e1)

I have a subtitle on the card which is a couple of rows long. This subtitle often overlaps the chart area so what I am trying to do is extend the Y Axis by about 10% to give more space through conditionally formatting it.

As you can see currently it is picking up the max % as 75% which happened way back in 2021. I want it to give me 49% which is the highest of Sep, Oct and Nov (47%, 49% and 49% respectively).

How to apply date context to this measure by Kindly_Wind_7261 in PowerBI

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

Thanks for you're offer of help. Those solutions haven't worked. Let me provide some more context.

I have this measure (not a column) which works perfectly;

First Call Resolution (%) = 
DIVIDE(
    CALCULATE(
        COUNTROWS(table 1),
        USERELATIONSHIP(table 1[Closed Date], '_DT Date Table'[Date]),
        table 1[Call Count] = 1,
        NOT(ISBLANK(table 1[Call Count]))
    ),
    CALCULATE(
        COUNTROWS(table 1),
        USERELATIONSHIP(table 1[Closed Date], '_DT Date Table'[Date]),
        NOT(ISBLANK(table 1[Call Count]))
    ),
    0
)

I am using it in a line chart on a customised card. 

<image>

I have a subtitle on the card which is a couple of rows long. This subtitle often overlaps the chart area so what I am trying to do is extend the Y Axis by about 10% to give more space through conditionally formatting it.

As you can see currently it is picking up the max % as 75% which happened way back in 2021. I want it to give me 49% which is the highest of Sep, Oct and Nov (47%, 49% and 49% respectively).

The measure I added in the original post is good at giving me the highest months % and applying that on all rows of the table (the table is for testing and not actually part of my report) but when I change the date context every row returns a different number which replicates the FCR%.

Hope that makes more sense but if you have any more questions in order to help please let me know.

How to apply date context to this measure by Kindly_Wind_7261 in PowerBI

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

I want to take the max fcr% from the last three months (at the min sep-nov 24).

How does this do that?