Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Did you find any solution?
Hi OkbaBG,
You can use a visual level filter like below to achieve your requirement.
Regards,
Jimmy Tao
What if you want to do this with a value selected from another visual instead of a static value?
Did you find a way to do this?
https://www.sqlbi.com/articles/using-the-selectedvalue-function-in-dax/
I hope this article provides you with a solution
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..
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
User | Count |
---|---|
122 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
92 | |
67 | |
62 | |
52 |