Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
86 | |
76 | |
74 | |
56 | |
45 |
User | Count |
---|---|
117 | |
105 | |
77 | |
66 | |
64 |