# percentages

• ### Question

• i have a matrix whose rows are site and some demographic (age, sex, country,...)

columns are a set of year (2017,018,2019...)

the values I want are count of people, and percentage of people meeting some criteria. I created a column on the table with is 0 or 1 depending on whether they meet the criteria.

I have the measure:

total = sum('table'[people with criteria]) this works fine.

I want the percentage of people, so I made a measure:

﻿﻿﻿﻿%Persite = DIVIDE (
'measuretbl'[total],

CALCULATE ('measuretbl'[total], ALL ( 'dimSite' ) ) this also works fine

however, when I expand and to see the demographic breakdown, the percentages are meaningless.

how do I create a measure which will give me the correct percentages even when expanded.

(percentage of each demographic relative to the total of the expanded site.

so if the site is 10% of the total for all sites, by demographic I should see values totaling to 10%)

this is what I am seeing. (top bolded row is for a site, rest of rows are expanded for a demographic)

﻿

thanx

???

Sunday, January 5, 2020 1:37 PM