Forum Discussion
Helper IIFilter a table based on concatenated values
DIACHROMA OK, try this as the RETURN then:
COUNTROWS(DISTINCT(SELECTCOLUMNS(FILTER(__AllRefsTable,[__Ref]<>BLANK()),"__Ref",[__Ref])))
Helper IIIt returns this error :
Community ChampionDIACHROMA Well that makes no sense since the length of the text should be the same for the measure! Let's try another route, create this the same measure that returns 1446 but with this in the last RETURN line and maybe put it in a Card visual or something:
CONCATENATEX(DISTINCT(SELECTCOLUMNS(__AllRefsTable,"__Ref",[__Ref])),[__Ref],",")What we are looking for is ",," for example or some other value that doesn't look quite right.
- DIACHROMA
It works !!!!!! 😊
A big thank you Greg_Deckler , you can't imagine how much you helped me today (tonight for me)!
Thank you again and have a great weekend !!!
Pauline
- Greg_Deckler
DIACHROMA OK, try this as the RETURN then:
COUNTROWS(DISTINCT(SELECTCOLUMNS(FILTER(__AllRefsTable,[__Ref]<>BLANK()),"__Ref",[__Ref]))) - DIACHROMA
Ok ! I did it, it returns Visit IDs in one value. I export the result to excel to check it, I have 1445 IDs in total.
I don't know if it can help, but the 1 which is extra in the total appears when I select a product which should normally show me Blank or 0. Isn't there something in the formula that could make 1 to this product that should not appear?
DIACHROMA Greg_Deckler Could someone please share sample .pbix for working solution