Forum Discussion
Having Issues using Calculate function, seems to be a problem with the PLACEHOLDER
Hi Corey, first thing, thanks for your support. Please see the image attached. On left side you can see the result I am trying to get, that table shows [Issues], [MY] and the measure [Contains], with an specific filter (on that visual) that only displays values where Contains = 1. You can see that I have selected MY= 2019 on the filter [MY_Sel]
In the table on the right side I added the measure you suggested [Issue by MY_] and the MY, the error message says: "A table of multiple values was supplied, where a single value was expected" I tried with and without the ALL(). Do you know what can be causing this error?
Could you share more information about what the end goal is?
The issue is in using Values as it can return a table (with multiple values) when you add it to the visual it expects a single value. but if your end goal is to say count the number of issues by model year like this:
The measure works fine by just switching to countrows to get a single numeric value.
edit: to clarify I guess I am confused on how you expect the table on the right should differ from the table on the left when working.