March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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 ..
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
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!!
Proud to be a Super User! | |
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 .
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
25 | |
17 | |
16 | |
12 | |
11 |
User | Count |
---|---|
40 | |
27 | |
27 | |
21 | |
19 |