Forum Discussion

ematheny's avatar
ematheny
Frequent Visitor
5 years ago
Solved

Conditional Measure Returning List of Values

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 budge...
Need Help
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    4 years ago

    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's avatar
MFelix
Super User
5 years ago

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.