Forum Discussion
HASONEVALUE() question
Hi, I'm having a few problems displaying a PDF in a report im currently working on. Everything worked fine before the start of the weekend. However, when i tuned in this morning, something se...
tensixtyone , Are you creating a measure or a column>
HASONEVALUE should be used in measure and it check if only one value is filtered
refer if needed
https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
Im creating a new column, as the PDF viewer doesnt take a measure
tensixtyone , I doubt it is a suitable to function for a new column
just try
CONCATENATEX('Query2', 'Query2'[Pic], , 'Query2'[Index], ASC)
Just tried out your suggestion, however it doesn't seem to work. It adds the different PDF's base64 string together instead of seperating them