Conditional Measure Returning List of Values

[ematheny]

I need to make a conditional measure that returns a list of values to be put in a matrix. I have an API with article data and i need to pull in articles based on whether or not a cost goes over budget.

I was thinking something along the logic of:

IF ([cost] > 500, (return list of article names), (else blank))

but seeing as IF() will only return a single value, this measure does not work.

Does anyone have any suggestions/ideas as to how to create this conditional measure?

[Anonymous · Accepted solution]

Hi @ematheny ,

Measures cannot return a list of values. It can return the following results.

Measure = IF(MAX('Table'[cost] )> 500,MAX('Table'[article names]),BLANK())

If this isn't what you want, please show me the results you expect.

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.

[MFelix]

Hi @ematheny ,

Measures cannot return more than one value has a result you cannot return a list of values to the final result of your measure.

What is the purpose of this list and what do you want to see?

Can you please share a mockup data or sample of your PBIX file and expected result. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.