Use Parameter to filter specific values from same column

[Anonymous]

Hi,

I got a graph which I am trying to filter with a parameter. One part of my parameter is based on a column with 3 different values Tier 1 Tier 2 and Tier 3. And I am only trying to use a filter at this part of my parameter.

My parameter looks like this. 

Cluster = {

    ("Tier "; NAMEOF('Location'[Tier ]); 0);  <- Tier 1 / Tier 2 / Tier 3 

    ("type"; NAMEOF('Location'[type]); 1); 

    ("way"; NAMEOF('Location'[way]); 2)

}

My graph looks like this. 


What I am trying to do is to use my parameter which is currently filtering this 3 lines to filter only Tier 1 and Tier 2 so the Tier 3 line wont appear in my chart. 
I cant use a simple filter because this would influence my other Parameter. 

[Anonymous]

Hi @amitchandak,

thank you for your response! The Measure worked! I thought if I am using a filter the measure will add up the values to one value. 

Thank you!

[amitchandak · Accepted solution]

@Anonymous , You can also use field parameter in filter to show the value of selected parameter and filter that for Tier1 and Tier 2.

Power BI- Create dynamic slicers using field parameters: https://youtu.be/H2ZxWaHAJZQ
https://medium.com/@amitchandak/power-bi-power-bi-create-dynamic-slicers-using-field-parameters-2025...

Or use a measure with Tier1 and Tier 2.

Calculate([Measure],filter(Location, Location[Tier] in {"Tier1 ","Tier2"}) )