Filter value of a measure for a chart

[Anonymous]

Dear all,

Could you please advise below issue?

I created a measure with 2 value is 1 or 2. 

Now, I want to apply the filter for value this measure (is 1) in a specific chart, but I cannot add measure to filter.

Please advise the technique.

Thanks so much!

[v-robertq-msft · Accepted solution]

Hi, @Anonymous 

What’ the chart you used to filter the value of measure?

I’ve also created some data and created a table chart to filter the measure, and I can successfully place the measure into the visual filter to filter it, like this:

Then I guess that you might use the page filter or the report filter because measure can’t be placed into the page filter or the report filter:

Therefore, I suggest you to click on the visual first to add this measure into the visual filter to filter it and check if it can work

You can download my test pbix file below

More info about understanding types of Filters in Power BI

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

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

[amitchandak]

@Anonymous , Not very clear.

If you have to create a measure like this, you should able be able to filter  1 in a visual

calculate(sum(Table[Value]), filter(Table, Table[column] in {1,2}))

[Anonymous]

Hi,

Below is my measure 

Stock cover turn to over = if(and([Max stock cover days]>28,[Min stock cover days]<28),1,2)

So I want to apply the result from this measure to a chart. The chart only show value matching [Stock cover turn to over] is 1.

Could you please advise?