I have a problem with DAX. First thing first, I have a suite of example data like this.
My requirement is when I select Model on Slicer, it will show only lower prices.
Such as when I select on model E(1402). Now the models A(1202), B(1003), D(1402), E(1402) and G(1001) are shown.
Then I want to change a filter to Model A. This case the models that lower prices also display (A, B and G)
Thank you for sharing your experience.
Go to Solution.
After my research, You can do this as below:
add a fact model table and do not create the relationship with basic table
Table = VALUES(Table2[Model])
drag the filed Model of Table into slicer
Add a measure as below:
Measure = var _filter=CALCULATE(MAX(Table2[Price]),FILTER(ALL(Table2),SELECTEDVALUE('Table'[Model])=Table2[Model])) return
when you do not select any model:
If you do want to show any data
then drag measure into the visual level filter and set is not blank
If you do want to show all data
then add a new measure
Measure 2 = IF(ISFILTERED('Table'[Model]),[Measure],MAX(Table2[PriceModel]))
then drag measure 2 into the visual level filter and set is not blank
After select model
here is pbix, please try it.
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!
Check out what's new in the Power BI Community!