filter and show only values greater than selected.

[OkbaBG]

Hi, I need some help to create a simple DAX function that filters all values in a table/visual that are greater than a selected value corresponding to a number associated to a brand.

For example:

Nike   1000

addidas  3000

Puma   2000

New Order 2500

My Brand 2200

I want to create a Dax function that only selects and shows in table the brands and their sale numbers that are greater than "My Brand" .. 

Any advice would be welcome.. thx in advace. 

[Anonymous]

Did you find any solution?

[v-yuta-msft]

Hi OkbaBG,

You can use a visual level filter like below to achieve your requirement.

 

Regards,

Jimmy Tao

[Ocoder]

What if you want to do this with a value selected from another visual instead of a static value?

[Anonymous]

Did you find a way to do this?

[Hardik]

https://www.sqlbi.com/articles/using-the-selectedvalue-function-in-dax/

I hope this article provides you with a solution

[OkbaBG]

thanks, but Selectedvalue returns the catagorical name ("My Brand"), I would like the measure to return the coresponding numeric value in the table. So I can then create another measure that returns all values greater than that number.. 

[OkbaBG]

Measure = AVERAGEX(FILTER('USWITCH TABLE (Pivot)', RELATED('USWITCH Supplier/Plan'[supplier]) = "British Gas"), 'USWITCH TABLE (Pivot)'[Value])

Measure 2 = AVERAGEX(FILTER('USWITCH TABLE (Pivot)', [average values] >= [Measure]), [average values])

these two measures do not seam to filter out the values as i wish.. any idea why the > sign does not work, but when i replace it with = then it does and filters the value down to one row for british Gas