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.

Anonymous's avatar
Anonymous
Not applicable
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.