Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Dividing two values in different tables

I currently have 2 tables: Sheet 1 and Census data.   I have built the census data to show:   Census Data Age/Gender = DATATABLE( "Age Group Name",STRING, "Male",INTEGER, "Female",INTEGE...
COUNT
crossjoin
Data Source
divide
Table
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    You need to use the Age Group column from your Census table in the matrix instead, and then you can use this measure to get your result.

     

    NewMeasure =
    DIVIDE (
        COUNT ( Sheet1[Event ID] ),
        AVERAGE ( 'Census Data Age/Gender'[Total] )
    ) * 100000

     
    Regards,
    Pat
     
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Followed what you said there and my numbers seem a little off. E.g. week 27  0 -4yrs has 6 counts so should be divided by 331515 *100000 = 1.8

where i get  trying to figure out where the calculations are deviating.

Thanks for the help so far mahoneypat 

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Anonymous  In my file, I do have 1.8 for 27 weeks 0-4 yrs.  Do you have other filters on the visual?

Regards,

Pat