topic Re: How to calcuate vehicle service loyalty with DAX messures? in DAX Commands and Tips

How to calcuate vehicle service loyalty with DAX messures?

Ruga — Tue, 10 Nov 2020 08:32:30 GMT

I am creating a report and I`m having som problems of getting the correct visuals.

What I`m after is to display vehicle serivce loyalty (customer loyalty) per dealership.

tables i can work with

Sales_2019 one dealer_ Invoice_Date

Vehicle_registration_date_Total_Vehicles(Whole country).

Belonging_Dealership (Which licence plate belonging to which dealership)

So far I am able to display total vehiclemaintenance made by vehicle registration year for the specific dealer based on sales in 2019. What I need in addition is to display on the same column chart is total vehicles avaiable by the belonging dealer on top of the chart to see how many of the vehicles that "belongs" to this dealer actually shows up for vehicle maintenance.

I tried the "all" expression but I`m not able to use it in the chart without getting an error. Also if I unfilter the table (registration date), all of the vehicles in the whole country not only the belonging dealership will be displayed. The numbers will be too high if the whole country is the reference and not the specific dealership.

How can I solve this issue?

is?

Re: How to calcuate vehicle service loyalty with DAX messures?

AlB — Tue, 10 Nov 2020 09:53:41 GMT

Hi Ruga

I don't quite understand what you are trying to do. Can you show the code for the measure that returns the error. And the code for the measure you are using in the chart? Showing a sample of your tables and their relationships would be of help

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers

Re: How to calcuate vehicle service loyalty with DAX messures?

Ruga — Tue, 10 Nov 2020 12:03:48 GMT

This shows the amount of invoices in regards of registration dates of vehicles. this is OK, but I dont see how many of the total cars registrated in the dealership responsibility that shows up. It should look something like this

Dark blue: Total vehicles available:

Light blue: vehicles showed up for maintenance.

in this example the loyalty is 50%, but in reality the loyalty do decline with age.

tables

Table_ MF_Drammen_Invoice_2019 example:

does this make any sense AlB ?

Re: How to calcuate vehicle service loyalty with DAX messures?

AlB — Wed, 11 Nov 2020 11:01:15 GMT

Ruga

I begin to understand, but not completely I'm afraid.I'd need to see the code for the measure you are using in the very first chart you show?

and the code for the measure that returns the error.

The code might help clarify what you are trying to do.

It would help too if you can share the pbix

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers

Re: How to calcuate vehicle service loyalty with DAX messures?

Ruga — Fri, 13 Nov 2020 12:27:46 GMT

Hi AlB . I tried to remove the filter on registration numbers by using "all" function in a new measure. Now I am not able to place this new measure under values in the chart. Im not sure if this is the correct way to do this.?

Re: How to calcuate vehicle service loyalty with DAX messures?

Ruga — Wed, 16 Dec 2020 10:05:35 GMT

I resolved this by adding the total cars as a secondary axis.