Forum Discussion

cosminc's avatar
cosminc
Post Partisan
8 years ago

current selection box

Hi how did you manage to solve this: when you  use some slicers from a page how can you see what filters are applied and what items are selected? what can i do to have the items selected on a slicer...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI cosminc,

 

>>with the measure which you gave me i put only one column and it repeats many time the value selected, i want to see only once 

It means you table contains duplicate records. Please try to use below formula to generate selected distinct items from specific table:

 

Select Item For 'Column Name' =
CALCULATE (
    CONCATENATEX ( VALUES ( 'Table'[Column Name] ), [Column Name], "," ),
    ALLSELECTED ( 'Table' )
)

 

>>what is the wright measure if in that table a have more columns filtered? 

Allselected function with table will get all filter effects from table, if you not want other column filter effect other column you can use all select(table[column]) to instead.

 

 

Regards,

Xiaoxin Sheng

 

cosminc's avatar
cosminc
Post Partisan
8 years ago

Hi,

it doesn't work

now they appear all the possibilities from a column, each posibility once; 2 problems: 1. when i don't select anything i want to be clean without all these items and 2. when i select an item or more i want to see only them, not all items.

Thanks for your help,

Cosmin