Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hierarchy Filter Selection

Hi,   In my dataset, Program belongs to school and School belongs to the Centre. For example, Centre 2 has 4 Schools under it and they offer together 33 programs and School 2, one of the schools of...
Need Help
Tips and Tricks
Tutorial Requests
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous 

To make measure work as expected, you could measures as below

ProgPerSchool  

AppPerSchool

AppAverageSchool

pro_school = CALCULATE(DISTINCTCOUNT(Sheet1[program]),ALLEXCEPT(Sheet1,Sheet1[centre],Sheet1[school]))

application = DISTINCTCOUNT(Sheet1[transaction])

app_school = CALCULATE([application],ALLEXCEPT(Sheet1,Sheet1[centre],Sheet1[school]))

ave_school = [app_school]/[pro_school]

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi v-juanli-msft , thanks for your time and guidance.

     

    The measures that you & I created work the same.  What they don't do is that if I select a program, it should pick automatically average of avg_school and avg_centre for comparison, and right now I have to pick it manually. If the end-user does not select a school and center from slicers after selecting a program, the output will be wrong which I want to avoid.