Need help with selectedvalue within a hierarchy slicer

[lalumiereMike]

Hello, 

I'm looking for guidance on figuring the appropriate DAX Formula structure for the following: 
I want to leverage a slicer that contains my entity rollup structure 
Groupe Conso > Division > Secteur > Etablissement_GroupeDescription > Etablissement_ID_Description
My desired if to have a formula that returns the appropriate value of Dim_Etablissements_complet, in a way that : 

If only a value of Etablissement_ID_Description is selected it returns the Selectedvalue(Etablissement_ID_Description) 
if not all values of Etablissement_ID_Description are selected within that node (e.g. Etablissement_GroupeDescription) then it concatenates Selectedvalue(Etablissement_ID_Description) such as 031 ; 032
if (4) a group value from Etablissement_GroupeDescription is selected then it returns the Selectedvalue(Etablissement_GroupeDescription)
if (3 ) a secteur value from Secteur_Description is selected then it returns the Selectedvalue(Secteur_Description)
if (2 ) a division value from Division_Description is selected then it returns the Selectedvalue(Divison_Description)

Here are  my set of variables

VAR _SelectedGroupConso=SELECTEDVALUE('Dim_Etablissements_complet'[GroupeConso_Description])

VAR _SelectedDivision=SELECTEDVALUE('Dim_Etablissements_complet'[Division_Description])

VAR _SelectedSecteur=SELECTEDVALUE('Dim_Etablissements_complet'[Secteur_Description])

VAR _SelectedGroupeEtablissement=SELECTEDVALUE('Dim_Etablissements_complet'[Etablissement_GroupeDescription])

VAR _SelectedEtablissement=SELECTEDVALUE('Dim_Etablissements_complet'[Etablissement_ID_Description])

Thanks in advance for you help, 

Mike

[Anonymous]

Hi @lalumiereMike ,
I wanted to follow up on our previous suggestions regarding the issue you are facing. We would like to hear back from you to ensure we can assist you further. If our response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. 
Thank you.

[Anonymous]

Hi @lalumiereMike ,

As we have not received a response from you yet, I would like to confirm whether you have successfully resolved the issue or if you require further assistance. If the issue has been resolved, please mark the helpful reply as a "solution" to indicate that the question has been answered and to assist others in the community.

Thank you for your cooperation. Have a great day.

[Anonymous]

Hi @lalumiereMike ,
I wanted to follow up on our previous suggestions regarding the issue you are facing. We would like to hear back from you to ensure we can assist you further. If our response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. 
Thank you

[Anonymous · Accepted solution]

Hi @lalumiereMike ,
Thank you for reaching out to us on Microsoft Fabric Community Forum!
Thank you @lbendlin for the prompt response!Upon my understanding,In addition, please follow the below steps.

• Create a hierarchy in Power BI using the following columns (GroupeConso_Description, Division_Description, Secteur_Description, Etablissement_GroupeDescription, Etablissement_ID_Description)
• Use the following measure to dynamically return the appropriate value based on the slicer selection:
   
  Selected Entity Label =

  VAR _SelectedEtablissements = VALUES('Dim_Etablissements_complet'[Etablissement_ID_Description])

  VAR _CountEtablissements = COUNTROWS(_SelectedEtablissements)

  
  

  VAR _SelectedGroupeEtablissement = SELECTEDVALUE('Dim_Etablissements_complet'[Etablissement_GroupeDescription])

  VAR _SelectedSecteur = SELECTEDVALUE('Dim_Etablissements_complet'[Secteur_Description])

  VAR _SelectedDivision = SELECTEDVALUE('Dim_Etablissements_complet'[Division_Description])

  VAR _SelectedGroupConso = SELECTEDVALUE('Dim_Etablissements_complet'[GroupeConso_Description])

  
  

  RETURN

  SWITCH(

      TRUE(),

      // Only 1 Etablissement selected

      _CountEtablissements = 1,

          SELECTEDVALUE('Dim_Etablissements_complet'[Etablissement_ID_Description]),

  
  

      // Multiple Etablissements selected AND no higher-level selection

      _CountEtablissements > 1

          && ISBLANK(_SelectedGroupeEtablissement)

          && ISBLANK(_SelectedSecteur)

          && ISBLANK(_SelectedDivision)

          && ISBLANK(_SelectedGroupConso),

          CONCATENATEX(

              _SelectedEtablissements,

              'Dim_Etablissements_complet'[Etablissement_ID_Description],

              " ; "

          ),

  
  

      // Higher levels: check in order of hierarchy

      NOT ISBLANK(_SelectedGroupeEtablissement), _SelectedGroupeEtablissement,

      NOT ISBLANK(_SelectedSecteur), _SelectedSecteur,

      NOT ISBLANK(_SelectedDivision), _SelectedDivision,

      NOT ISBLANK(_SelectedGroupConso), _SelectedGroupConso,

  
  

      "No Selection"

  )
  

• Add this measure to a cardvisual to reflect the user’s slicer selection. The measure will adapt as users drill down or select multiple items.Refer the attached screenshot and file for your reference.

  

If this solution meets your requirement,consider accepting it as solution.

Regards,
Pallavi.

[lbendlin]

SELECTEDVALUE work ONLY if you have a SINGLE value selected.  That is not the case in your scenarios.  Use VALUES instead.