Urgent : Create filter from 2 columns conditions

[Anonymous]

Hi Everyone,

I would like to show indicators "co_indic" and "valeur" for differents stores. I would like to filter by section of store colonne "rayon".

My data :

Point de Vente	code_Indicateur	Valeur	Rayon	Tous rayons
Paris	ACT58960	0,8	Femme	0
Paris	ACT58960	0,5	Homme	0
Paris	ACT58960	0,75	Enfant	0
Paris	ACT58960	0,7	tous rayons	1
Lille	ACT58960	0,85	Femme	0
Lille	ACT58960	0,68	Homme	0
Lille	ACT58960	0,2	Linge de maison	0
Lille	ACT58960	0,6	tous rayons	1
Lyon	ACT58960	0,25	Linge de maison	1
Bordeaux	ACT58960	0,3	Enfant	1
Paris	ACT58963	1800	Femme	0
Paris	ACT58963	956	Homme	0
Paris	ACT58963	6943	Enfant	0
Paris	ACT58963	9699	tous rayons	1
Lille	ACT58963	200	Femme	0
Lille	ACT58963	1956	Homme	0
Lille	ACT58963	3943	Linge de maison	0
Lille	ACT58963	6099	tous rayons	1
Lyon	ACT58963	6548	Linge de maison	1
Bordeaux	ACT58963	2365	Enfant	1

However, I want when "all sections" is selected to display indicators for stores, all departments. My Problem is that a store can only have one section and therefore the "tous rayons" line is that of the section. This line is indicated by the "Tous rayons" column which takes the value 1. How to do so that when I filter on the "tous rayons" value of the "rayon" column, we also display the stores which have only one single section. I have this:

and I would like this:

I have tried Hierachical Filter but it not resolved my problem, cause when I select "Enfant" Bordeaux store doesn't appear :

Thank's for your help.

[lbendlin]

The easiest approach would be to create a disconnected table with the Rayon values, use that to feed the slicer, and then create a measure that checks the SelectedValue  ( or FILTERS ) of that slicer's table.

Ref = VALUES(Table2[Rayon])

Note1: I know, there's a bug in the measure if tous rayons is selected together with another range.

Note2:  Be aware that the same result can be achieved by clearing the slicer selection, so "tous rayons" is not really required if you can educate your users.

[Anonymous · Accepted solution]

Hi @lbendlin ,

Thank's for your answer, 

I modified your proposal and like that I have no bug when "tous rayons" is selected:

Val2 =
IF (
HASONEFILTER ( Ref[Rayon] )
&& SELECTEDVALUE ( Ref[Rayon] ) == "tous rayons",
CALCULATE (
SUM ( commerce[Valeur] ),
ALL ( commerce[Rayon] ),
commerce[Tous rayons] = 1
),
CALCULATE ( SUM ( commerce[Valeur] ), TREATAS ( Ref, commerce[Rayon] ) )
)

Thank you