Forum Discussion

blackhawk93's avatar
blackhawk93
Regular Visitor
4 years ago

DAX function for finding accident count against vehicle types

I have a table with road accident details and there's another table with vehicle details involved in the accident. I need to get a count of accidents happened against each vehicle type. For example a...
General Comment
Need Help
Show and Tell
Tutorial Requests
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi blackhawk93 

how does your source data look like?

  • blackhawk93's avatar
    blackhawk93
    Regular Visitor
    4 years ago

    Hi , it was extracted from the access databases. 

     

    Was this helpfull to get an idea?

     

     

    • blackhawk93's avatar
      blackhawk93
      Regular Visitor
      4 years ago

      Do you need the contents  of the tables (inside views) ?

      • tamerj1's avatar
        tamerj1
        Icon for Community Champion rankCommunity Champion
        4 years ago

        blackhawk93 

        Yes, would you please provide a copy paste sample data?