Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to create a matrix-like table in the data view?

Hi everyone,   I need your help with the following. I've been struggling for hours 😞   I uploaded the following table as an Excel file into BI desktop.   Incident Type Incident Date Hospi...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    5 years ago

    Anonymous 

    See if this works for you. First the model:

     

    Now the measures:

    Count of Injuries = COUNT('DataTable'[Incident Type])
    Population = SUM(Population[Population])
    Injuries per 1000 population = 
DIVIDE([Count of Injuries], [Population]) * 1000

     

    And this is the result:

     

    I've attached the PBIX file for you

Z_T_W's avatar
Z_T_W
New Member
5 years ago

Hi there Anonymous,

 

I'd be glad to help you out here. Quick question though; wouldnt you need more data to complete this calculation?

 

Maybe something like 'Total Number of Employees.' at each hospital. Do you have this data?

 

Regards,

 

Zach W.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hola Zach,

    So I have created a separate table with population/number of employees for each hospital and linked them (in the model view) on the name of the hospital. I don't know if this is the best way to do it but that was the only one I could think of!

    Thanks,

    Maggie