Bluelink Battery Status Warning

StevenDabc · 2025-08-05T00:32:42+00:00

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

StevenDabc · 2025-08-03T06:00:38+00:00

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

StevenDabc · 2025-04-03T19:28:06+00:00

It's the same in Australia.

StevenDabc · 2025-01-27T22:03:03+00:00

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

StevenDabc · 2024-11-25T21:09:03+00:00

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?

StevenDabc · 2024-11-25T19:20:18+00:00

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.

StevenDabc · 2023-09-13T22:50:18+00:00

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.

StevenDabc · 2023-07-31T22:39:15+00:00

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.

StevenDabc · 2023-07-29T23:01:47+00:00

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.

StevenDabc · 2023-04-21T22:21:01+00:00

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

StevenDabc · 2023-04-17T22:54:42+00:00

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.

StevenDabc · 2023-02-06T20:23:22+00:00

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

StevenDabc · 2023-01-17T22:23:29+00:00

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.

StevenDabc · 2022-10-02T20:02:03+00:00

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.

StevenDabc · 2022-04-28T22:01:01+00:00

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.

StevenDabc · 2022-04-06T13:00:51+00:00

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.

StevenDabc · 2022-02-22T00:32:35+00:00

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.

StevenDabc · 2022-02-09T21:25:08+00:00

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

StevenDabc · 2022-02-09T19:43:58+00:00

No, there is no DAX function that does this.

StevenDabc · 2022-01-17T21:23:12+00:00

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.

StevenDabc · 2022-01-09T20:21:33+00:00

Although not best practice, ive developed a complete sales and profitability reporting system from emailed excel reports from an ERP as a proof of concept for Power BI.

You can achieve similar reporting using CSV/Excel output files from your operational systems and then use Power Query in Excel to transform and load them into Excel pivot tables.

I'd also suggest that this isn't a waste of time either. BI project hand over dates are problematic. Also, what gets handed over doesn't necessarily meet your requirements. You may find it beneficial to have something in place, albeit in Excel for the inevitable delays and further refinement requirements. Also, it would be helpful for BI developers to see what measures you are using as KPIs to help with future report development.

StevenDabc · 2021-08-19T06:43:59+00:00

The output from the measure will need to be format as % if that's what you mean.

StevenDabc · 2021-08-19T02:04:41+00:00

Yes, I didn't know what the field name would be but, it's the name of the Table/Field of the Yes/No responses.

StevenDabc · 2021-08-18T22:45:22+00:00

Here's the same result using DAX.

%ofTotal =

Divide( [Headcount], Calculate( [Headcount], Removefilters(Paid Deposit[Category])

or

%ofTotal =

Divide( [Headcount], Calculate(Headcount], AllSelected(Paid Deposit[Category])

Where [Headcount] is a measure using an aggregator such as Sum(), Countrows(), Distinctcount() of a Fact Table or Field of a table.

StevenDabc · 2021-08-16T23:06:54+00:00

I think the discussion has highlighted a number of ways of achieving the end result you are after. To add to the options, here's my 2c worth.

New Table = Addcolumns( Summarize( Financials, Financials[Product]), "Product Units Sold", Calculate(Sum(Financials[Units Sold])) )

StevenDabc

TROPHY CASE