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.
Kopek if we stay in the box 🙂 we can leave the measure and just hide it (make the column headers and values not wrap and jsut minimize it to not be shown) - the measure is actually there:
In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.
SpartaBI Logo
Visit SpartaBI website Visit SpartaBI Linkdin Visit SpartaBI Facebook
Showcase Report – Contoso By SpartaBI
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