Hierarchy Filter Selection

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.