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
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

Hi,

On the first sheet, i just see a lot of Tables and that is what is causing a lot of confusion.  Please explain exactly which cell ha s problem, what answer are you expecting in that cell and why.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Ashish_Mathur ,

     

    Thanks for the response.  I have some serious issue with DAX formula and filter context which gives an erroneous result.

     

    The measures will produce the final output and values of the measure should vary depending on the slicer selection. The measures give correct output for centre selection but it breaks when I select a school from slicer or program from the slicer.

     

    Measures that will be used as final output

    When I select a school -1 from the slicer, the AppPerCentre and ProgPerCentre give output for the school-1 and not for centre -1.

     

     

    Similarly, if when I select program-GGG111 which belongs to School-1 and Centre-1, the output for school and centre is completely inaccurate.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      7 years ago

      Hi,

      Given the multiple Tables there, i will take quite some time to understand your data structure and relationships.  I will not be able to help you with this - Sorry.  Someone else will help you.