how to filter on the top 5 of each level of a hierarchy

[Cobra77]

Hi ,

how to filter on the top 5 of each level of a hierarchy ?

Thanks for your help.

Best regards.

[rajendraongole1]

Here is a blog describing Ranking with Hierarchy Drill-Down for your reference.

If this post helps, then please consider Accept it as the solution to help the other members find it more

[Cobra77]

Hi @rajendraongole1 , thanks for the link

I'm trying, but as soon as I add level 3, and put the rank to filter the first 5, the isfiltered tests on the levels are true for the 2 levels

[v-frfei-msft]

Hi @Cobra77 ,

We can use ISINSCOPE to work on it instead of isfiltered.

Measure = IF(CALCULATE(SUM('Table'[value]))<>BLANK(),IF(ISINSCOPE('Table'[date].[Day]),RANKX(ALL('Table'[date].[Day]),CALCULATE(SUM('Table'[value])))))

For more details, please check the pbix as attached.

[Cobra77]

hi @v-frfei-msft , @rajendraongole1 

my pbix report is based on a live connection to an SSAS tabular 2016.

I don t have the function ISINSCOPE 😞

neither in visual studio nor in the pbix on the cube