Create a slicer based on the dynamic conditional filter

[Dipak_22]

Hi Everyone i am facing a roadblock with the power bi slicer

There's a "Scope" Named column in the table which is added in power bi for report creation. This Columns Contains following information or variables:
1.Never Protected
2.No Longer Protected
3.Protected
4.Protection Not Covered
5.Protection Under Investigation
6.Protection Unknown
I want to Create a column using measures which will contain two Filter option which is mentioned below:
"Incl. patent-protected products"
"Excl. patent-protected products"

this is the sample Data

Name	Scope	Price
A	protected	254
B	Never Protected	175
C	No Longer Protected	295
D	Protection Unknown	355
E	protected	450
F	Protection Not Covered	210
G	Protection Under Investigation	152

this is how the variable looks into the normal slicer in power bi

and I am expecting a result like below:

so the Incl. patent-protected products should contains all the values or variables from Scope column and Excl. patent-protected products should contains all the variables except "Protected"

Can i get an idea how to resolve this ASAP

[v-tianyich-msft]

Hi @Dipak_22 ,

I made simple samples and you can check the results as follows

Group = var _s = [Scope]
RETURN SWITCH(TRUE(),
_s="Never Protected","Excl. patent-protected products",
_s="No Longer Protected","Excl. patent-protected products",
_s="Protection Not Covered","Excl. patent-protected products",
"Incl. patent-protected products")

An attachment for your reference. Hope it helps!

Best regards,
Community Support Team_ Scott Chang

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

[Dipak_22]

Hi Thanks for trying but this is not the solution i am looking for let me rephrase the expecting result as per the pbix you provided
so if under the Incl. patent-protected products have protected, protection unknown and protection under investigation 

Name	Scope	Sum of Price	Group
A	Protected	254	Incl. patent-protected products
D	protection unknown	355	Incl. patent-protected products
E	Protected	450	Incl. patent-protected products
G	protection under investigation	152	Incl. patent-protected products

 then under Excl. patent-protected products should have protection unknown and protection under investigation but not protected like this 

Name	Scope	Sum of price	Group
B	protection under investigation	175	Excl. patent-protected products
C	protection unknown	295	Excl. patent-protected products
F	protection unknown	210	Excl. patent-protected products

please do let me know if this could be possible using something like parameters

[v-tianyich-msft · Accepted solution]

Hi @Dipak_22 ,

Please check that the following results meet your expectations:

An attachment for your reference. Hope it helps!

Best regards,
Community Support Team_ Scott Chang

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

[Ritaf1983]

Hi @Dipak_22 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523