Forum Discussion
How to select specific value?
- 7 years ago
hi, saranp780
After my research, You can do this as below:
Step1:
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
Step2:
Add a measure as below:
Measure = var _filter=CALCULATE(MAX(Table2[Price]),FILTER(ALL(Table2),SELECTEDVALUE('Table'[Model])=Table2[Model])) return CALCULATE(MAX(Table2[PriceModel]),Table2[Price]<=_filter)Step3:
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
Result:
After select model
here is pbix, please try it.
https://www.dropbox.com/s/r7rdj3xfh5tvt34/How%20to%20select%20specific%20value.pbix?dl=0
Best Regards,
Lin
hi, saranp780
After my research, You can do this as below:
Step1:
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
Step2:
Add a measure as below:
Measure = var _filter=CALCULATE(MAX(Table2[Price]),FILTER(ALL(Table2),SELECTEDVALUE('Table'[Model])=Table2[Model])) return
CALCULATE(MAX(Table2[PriceModel]),Table2[Price]<=_filter)Step3:
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
Result:
After select model
here is pbix, please try it.
https://www.dropbox.com/s/r7rdj3xfh5tvt34/How%20to%20select%20specific%20value.pbix?dl=0
Best Regards,
Lin