topic Re: calculating number of accidents per lakh vehicles in DAX Commands and Tips

calculating number of accidents per lakh vehicles

Analyst_in_prog — Tue, 18 Jun 2024 06:12:22 GMT

hey guys , i am having a probelm , I have accidental datarecord, some columns are
1. number of vehicles involved in accident (numercial column contains 1,2,....6 )
2. measure (total number of accidents )
3. Months name ( its is in dates table)
i want to calculate number of accidents per lakh vehicles ,over months .
# number of accidetns per lakh vehicles means .... Total Accidetns *100000 /vehicles over each month
please help me ..

Re: calculating number of accidents per lakh vehicles

rajendraongole1 — Tue, 18 Jun 2024 08:20:20 GMT

Hi Analyst_in_prog - Can you please provide some sample data with available fields from your dataset for reference.

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

Re: calculating number of accidents per lakh vehicles

Analyst_in_prog — Tue, 18 Jun 2024 08:36:38 GMT

hey rajendraongole1
the Data is in different tables , and there are several columns , thats why i am sending you the columns that we require :
is there any specific thing so please ask me i'll try to provide .

for total accidents i have created a measure .

Total_Accidents = COUNT(v3_dimensional[Crime Number])

Re: calculating number of accidents per lakh vehicles

Anonymous — Fri, 28 Jun 2024 07:19:06 GMT

Hi Analyst_in_prog

Use the following DAX formula for your measure:

Accidents Per Lakh Vehicles = SUM('YourTableName'[measure]) * 100000 / SUM('YourTableName'[number of vehicles involved in accident])

Best Regards,

Jaylen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly