Forum Discussion
Filtering on one item will select all previous items too
Hi, Anonymous
Thank you for your feedback.
In that case, you can have one more column in the Name Table, like below.
Please check the relationship every time you create new tables ( this case: NO relationship), if your setting is auto-relationship-create.
I changed a measure and please check in the sample pbix file link down below.
https://www.dropbox.com/s/6o3p3g2fmdgjcg1/fruit.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
Super UserHi, Anonymous
Please check the link down below.
If you do not want to see 1 as a result, you can insert this measure into the visual filters and select the option to show only 1.
You cannot sum alphabets.
In my previous pbix file, the data column was numbers. So I chose the sum function.
If you change the whole sample, you need to apply the proper function according to each column's data type.
And check the data model pane. In my last sample pbix file, the two tables were not connected. Please do not connect the two tables, in this case. If you do not check this after every time you create new model or new tables, in most cases, the relationship is automatically created, unless you change a setting.
https://www.dropbox.com/s/cn7wl9uc28f6i1t/fruit2.pbix?dl=0
Result =
VAR currentselect =
MAX ( 'Name'[Name] )
VAR currentnameorless =
SUMMARIZE (
FILTER ( ALL ( 'Name' ), 'Name'[Name] <= currentselect ),
'Name'[Name]
)
RETURN
IF ( SELECTEDVALUE ( Data[Name] ) IN currentnameorless, 1, BLANK () )
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
Hi thanks very much for you help and your patience, it is really appreciated.
This is very nearly what I need, it does behave correctly but there needs to be a slight tweak for my use case that I'm not sure how to apply.
This measure works under the assumption that the names are all in alphbetical order and shows equal to or less alphabetical values.
What I need is for the values shown to be based on the lower (or equal to) ref/index number order, not the alpabetical order of the values in the filter.
For example:
The Filter would still have A,B,C,D,E as values as before, however the values shown would be as follows:
Select A: Show A,B
Select B: Show B
Select C: A,B,C,D,E
Select 😧 A,B,E,D
Select E: A,B,E
- Jihwan_Kim
Hi, Anonymous
Thank you for your feedback.
In that case, you can have one more column in the Name Table, like below.
Please check the relationship every time you create new tables ( this case: NO relationship), if your setting is auto-relationship-create.
I changed a measure and please check in the sample pbix file link down below.
https://www.dropbox.com/s/6o3p3g2fmdgjcg1/fruit.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM