Possible to filter on a measure?

[OneWithQuestion]

If I have total sales and want to filter where greater than $500 is that possible? Can I use a slider to adjust on the fly?

[Vvelarde · Accepted solution]

@OneWithQuestion

Put the measure in visual level filter and filter it to is greater than 500

[Anonymous · Accepted solution]

Hi @OneWithQuestion,

You can also use dax formula to add condition to filter the measure:

For example:

Old measure
SubTotal =
var currProduct=LASTNONBLANK(Sheet3[Product],Sheet3[Product])
return
SUMX(FILTER(ALL(Sheet3),Sheet3[Product]=currProduct),Sheet3[Sales Amount])

Modified:
SubTotal =
var currProduct=LASTNONBLANK(Sheet3[Product],Sheet3[Product])
return
SUMX(FILTER(ALL(Sheet3),Sheet3[Product]=currProduct&&Sheet3[Sales Amount]>500),Sheet3[Sales Amount])

In addition, Vvelarde's point also works, but if you use the "all" filter in your measure, you should use "allselect" to replace it.

Regards,
Xiaoxin Sheng

[Vvelarde · Accepted solution]

@OneWithQuestion

Put the measure in visual level filter and filter it to is greater than 500