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 accident count for cars against bikes, cars against trucks etc.

 

I need to construct a table like this. 

 

 

General Comment
Need Help
Show and Tell
Tutorial Requests

7 Replies

    • 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) ?