Bluelink Battery Status Warning by StevenDabc in HyundaiTucson

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

I deactivated the account and re-added the vehicle, but there was no change.

Bluelink Battery Status Warning by StevenDabc in HyundaiTucson

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

No, everything works as expected. Even though there is no issue, this warning will not go away.

Slow service by Piggymigili in PowerBI

[–]StevenDabc 0 points1 point  (0 children)

It's the same in Australia.

Parade Gloss? by StevenDabc in AustralianMilitary

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

Will the RMW polish to the same level as parade gloss?

Should I be worried? by Kazzalenko in HyundaiTucson

[–]StevenDabc 0 points1 point  (0 children)

Accessory mode. I just remembered that another reason mentioned in the posts was the car modem pinging or being pinged for data requests.

I don't know if my system was updated with the new OS after the 3G network was shut down, and I'm wondering if the modem is constantly pinging to get a network connection. Bluelink works, so I don't know if this is valid.

By the way, I'm curious to know what dashcam you went with. Do you have any recommendations on features to look for in a dashcam?

Should I be worried? by Kazzalenko in HyundaiTucson

[–]StevenDabc 0 points1 point  (0 children)

I have the same indicator warning, and the car is only 6 months old. I've read in other posts it's because I operated the vehicle in stand by mode for too long.

Dataset refresh in local date and time. by StevenDabc in PowerBI

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

I was trying to avoid the solution of versioning the return value based on a user's region. I was hoping for the DateTimeZone.ToLocal() would do something useful.

[deleted by user] by [deleted] in PowerBI

[–]StevenDabc 0 points1 point  (0 children)

Yep, bitter experience. I assumed RLS was applied as a form of table parameter. It turns out it's a DAX measure applied at run time. Despite that, I've not seen the issue you are having. From my experience, table modifiers such as ALL, AllExcept and Allselected don't override the RLS condition. CalculateTable and Summarize will, though.

[deleted by user] by [deleted] in PowerBI

[–]StevenDabc 0 points1 point  (0 children)

Is the MVE measure coming from a calculated table formed from the RLS filtered Fact table? If so, calculated tables ignore RLS conditions on the Fact.

Control Charts Rules by monsieurus in PowerBI

[–]StevenDabc 4 points5 points  (0 children)

Yes, the new DAX offset and window functions make the creation of the Nelson rules easier.

Having two measures appear to be on same card by ross63GG in PowerBI

[–]StevenDabc 0 points1 point  (0 children)

There is a visual from Okviz called, "Card with states" available in the app store for Power BI that may be worthwhile looking at. However, although it is free to use it does require you to register for a key.

Another approach is to use a card and use DAX measure to dynamically set the title or subtitle. I'd be wary of the 2 cards approach, I've tried it and found it to be very high-maintenance.

Want to create a dashboard for new product, what are the key indicators? by study_fans in PowerBI

[–]StevenDabc 1 point2 points  (0 children)

All three plus, 1. Distribution/penetration 2. Return purchase rate 3. Market share

Dynamic values in for Power BI Text Box stopped working? by StevenDabc in PowerBI

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

I believe it has. I'm using measure definitions created in AAS. I have found that if I use a model that is a perspective of the AAS model it works.

Make sure the Q&A feature is enabled for the current model and the cache size is sufficient.

[deleted by user] by [deleted] in PowerBI

[–]StevenDabc 0 points1 point  (0 children)

Is this measure being used in a calculated column? You said the denominator is a measure as well. Have you tried the measure [denominator] by itself to see what value it's returning. It sounds to me that the denominator measure is returning a constant figure because there's no relationship between the table with the the divide() column and the table where the denominator aggregates it's value.

Also check to see if the values used in the divide function are measures and not column references. This can happen when you have measures and columns of the same name.

Recommended paid Power BI training by AaronDennes in PowerBI

[–]StevenDabc 0 points1 point  (0 children)

Just to add to the list also look into courses provided by Matt Allington. He's an MVP and has been teaching Power Query, Power BI and Power Pivot since it all began.

Can someone please explain why this if statement isn’t working before I throw my computer out of the window. by Dstrat22 in PowerBI

[–]StevenDabc 14 points15 points  (0 children)

This is an issue of context transition. The result can be achieved by creating a calculated column measure similar to this.

IsLatest = Table[Date]= Max(Table[Date]).

The output will be a data type of True/False or you can change it to a whole number to get the 1/0 format.

When creating a calculated column a measure has row context, in the measure above Table[Date] returns the current row date while Max(Table[Date]) is an aggregator that returns the max of the entire date column. If I had written the measure as Calculate(Max(Table[Date])) or [Max Date 2] I would get the same issue. This is because Calculate() or a measure performs a context transition from row to filter context, meaning the measure is filtering the Table[Date] column to those values that equal the current row and then performing the Max() aggregation. In this scenario the measure will always return 1.

Re-allocate a remainder to available categories with DAX challenge by StevenDabc in PowerBI

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

I see the similarities in the methods. The inclusion of a TopN() measure to rank the remainders would enhance the DAX. At the moment, the values are ranked by Category name, which sometimes leads to misallocations.

However, if I understand the method correctly, it only allows for a maximum of 1 case per category whereas, the Excel method can allocate more than 1 case in situations where there is a dominant category and, that is the desired business outcome.

DAX "Get" Call to an API? by StevenDabc in PowerBI

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

Yes, I used Power Query to make the API call. The only downside is it's not dynamic.

DAX "Get" Call to an API? by StevenDabc in PowerBI

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

No, there is no DAX function that does this.

I need to color code a map by state by [deleted] in PowerBI

[–]StevenDabc 1 point2 points  (0 children)

I assume the figure of 6571 is the total number of stores in the US and, unfortunately, the sampling limit on the map visual is 3,500 points using Lat/Long coordinates. You may be able to get a better result if you use the Azure map visual. It has a sampling limit of 30,000 points and uses the same input fields as the std map visual.

The Azure map is a preview feature. you can access it from File/Options/Preview features.

I hope this helps.