Filtering table by specific value for set number of weeks

[Justas4478]

Hello. I am trying to create a filter that will only return those results who have over a chosen amount for four of the five weeks.

Example I would want to filter for results that are >12 that should bring me results highlited in red as you can see in the screenshot.

Does anyone know can this kind of filter be created or it needs to be measure? In addition the value could change often so that should be taken in to the account. Thank you.

[Anonymous]

@Justas4478 1. You can use visual filter (without additional measure).

2. Second option (with additional measure) - to create new 'what-if' parameter.

[Justas4478]

@Anonymous I only have access to the measures since report is using Live connection. And I am restricted to only be able to use measures. So I dont have access to the columns and I cant use new parameter option since it is grayed out. Is there any onther way to do these things when I can only use measures? 

[Anonymous]

@Justas4478 Still you can use visual filter. Doesn't this solve your request?

[Justas4478]

@Anonymous I cant use measure in the visual filter. It does not allow me to place it there.

[Anonymous]

@Justas4478 It's strange because I can place measures in visual filter...

[Justas4478]

@Anonymous Yea I dont know why it doesnt allow me to do that.

[Justas4478]

This is the measure that provides values shown in the previous screenshot table. 

[Anonymous · Accepted solution]

@Justas4478 Try this then:

Voids Value = var tempMeasure = CALCULATE(SUM(Actuals[_Value]), 'Transaction Type'[TransactionType] = "Voids")

return IF(tempMeasure>12, tempMeasure, BLANK())

[Justas4478]

@Anonymous It looks like it is working as intended. Thank you so much.