DYNAMIC MEASURE TO DISPLAY FILTERED VALUES

[JemmaD]

Hi there,

I have a measure which checks if a slicer has been filtered and if so, it displays the items which have been selected and if not, it says "no filters".

However, for some reason it's showing several of each item selected - and I want it to be distinct. 

Here is my measure, can I specify that it shows distinct Product?

Filter Product = IF(ISFILTERED('Product'[Product]),CONCATENATEX('Product', 'Product'[Product], UNICHAR(10)), "No filters")

[SpartaBI · Accepted solution]

@JemmaD try:

Filter Product = IF(ISFILTERED('Product'[Product]),CONCATENATEX(VALUES('Product'[Product]), 'Product'[Product], UNICHAR(10)), "No filters")

      

Showcase Report – Contoso By SpartaBI