Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register 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 .
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
41 | |
36 | |
22 | |
21 | |
20 |