Forum Discussion
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 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?
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 _ PollyIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
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.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 _ PollyIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
