Forum Discussion
Helper IVDax for select All
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.
Helper IVYes, 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 ?
- SpartaBI
Community Champion
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 - Kopek
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