Forum Discussion

lukaninda's avatar
lukaninda
Frequent Visitor
3 years ago
Solved

Display selected hierarchy objects on a page

Hello, everyone! I create dashboards based on financial information of a group of companies. There is a two level organizational hierarchy - let's say Level 1 and Level 2. Sample structure looks lik...
Need Help
v-jianboli-msft's avatar
v-jianboli-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi lukaninda ,

 

Based on your description, I have created a simple sample:

Please try:

Level2 = SELECTEDVALUE('Table'[Level 2])

Final output:

 

Best Regards,

Jianbo Li

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

  • lukaninda's avatar
    lukaninda
    Frequent Visitor
    3 years ago

    Thank you, Jianbo! This works excatly as I needed. I actually didn't expect there was such an easy solution. I have worked out my own, which is customized for my specific needs. 

    First, I created a measure that counts currently selected entities. The formula is simple:

    entities_counter = COUNT('Table1'[Level 2])

    Then the same with clusters:

    clusters_counter = COUNT('Table1'[Level 1])

    Second, I create a measure, which value depends on the counters:

    entity_card = SWITCH(TRUE(),
'Table1'[entities_counter] > 1, "",
'Table1'[entities_counter] = 1, SELECTEDVALUE('Table1'[Level 2]),
BLANK())

    What I wanted from this measure is to show nothing ("") when 2 or more entities of Level 2 are currently selected.

    Measure for clusters is almost the same except for it shows the name of the holding when 2 or more clusters are selected:

    cluster_card = SWITCH(TRUE(),
'Table1'[clusters_counter] > 1, "Holding_name",
'Table1'[clusters_counter] = 1, SELECTEDVALUE('Table1'[Level 1]),
BLANK())

    I hope my solution will also be useful to someone.