Forum Discussion
Dax for select All
- Anonymous4 years ago
Hi Kopek ,
Please refer to my pbix file wo see if it helps you.
Create a new table based on the table.
Table_copy = SUMMARIZE('Table','Table'[Quarter])Then put the table_copy[Quanter] into the slicer.
Then create a measure.
Measure = IF ( SELECTEDVALUE ( Table_copy[Quarter] ) = "Select All" && SELECTEDVALUE ( 'Table'[Quarter] ) <> "Select All", 1, IF ( SELECTEDVALUE ( 'Table'[Quarter] ) = SELECTEDVALUE ( Table_copy[Quarter] ), 1, 0 ) )Then filter the measure.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yes, but it works only when measure is added agains qtrs, whereas i need a pure list of qtrs.
If SelectedValue = "Select All" give me full qtr list, otherwise show whatever selected. 🙂
Does it make any sense ?
- Kopek4 years ago
Helper IV
will not work either, since i use qtrs as a matrix columns 🙈 that's why i need to figure-out a measure which will filter qtrs accordinly, so that values in a matrix are updated accoridngly