none
percentages RRS feed

  • 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

Answers

  • I finally found it. the measure %persite must also remove all other filters so add more all('dim that may be filtered')

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

    CALCULATE ('measuretbl'[total], ALL ( 'dimSite' ),all('dim2' ),all(dim3))


    ???

    • Marked as answer by berli Wednesday, January 8, 2020 2:03 PM
    Wednesday, January 8, 2020 2:03 PM