topic Re: Need help with selectedvalue within a hierarchy slicer in DAX Commands and Tips

Need help with selectedvalue within a hierarchy slicer

lalumiereMike — Mon, 14 Apr 2025 17:22:47 GMT

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

Re: Need help with selectedvalue within a hierarchy slicer

lbendlin — Mon, 14 Apr 2025 18:23:09 GMT

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

Re: Need help with selectedvalue within a hierarchy slicer

Anonymous — Tue, 15 Apr 2025 07:16:34 GMT

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.

Re: Need help with selectedvalue within a hierarchy slicer

Anonymous — Thu, 17 Apr 2025 12:08:14 GMT

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

Re: Need help with selectedvalue within a hierarchy slicer

Anonymous — Mon, 21 Apr 2025 05:00:30 GMT

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.

Re: Need help with selectedvalue within a hierarchy slicer

Anonymous — Thu, 24 Apr 2025 04:57:40 GMT