Choosing what to display on summary level in a drilldown

[Anonymous]

Hey everyone

I am trying to prioritate in a measure what i want displayed at the top level of a drilldown.

To add context to pictur, the drilldown is like this:

Customer

Main project name + ID

Project ID

Then the column is a way to show what should be prioritated.

So EscEBBOD is prio 1 and should be shown on top of all drilldown levels

ESCBU is prio 2 and should be shown at top level if there is no EscEBBOD (So it should show over EscSBU

EscSBU is prio 3 and should only be shown on top drilldown level if the 2 others are not present.

Please let me know if anyone needs further context

[v-deddai1-msft]

Hi @Anonymous ,

You need to create a sort-order column for each column you need, e.g. one for category and one for subcategory. Then for each of these columns choose sort by column and select the appropriate column to sort by.

Best Regards,

Dedmon Dai

[amitchandak]

@Anonymous , Not very clear.

Check if this can help : https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/