error message

2 Topics

Error Msg: Unable to convert a value to the data type requested for the table " column ".
I'm working with a Direct Query from PBI Desktop to a Semantic Model stored in the cloud. The Semantic model has a number of measures defined, including quite simple ones like: Measure = SUM('table'[columName]) However, I'm consistently getting these error messages in Reports with the Direct Query. The measures work fine in the underlying PBIP that I'm using to define the Semantic model. I found some older posts about this error, but nothing recent. Is anyone seeing something similiar, is there a resolution beyond re-writing the measure 'locally' where the report is being authored? What is stranger is sometimes the measures work and sometimes they don't. If I drop them into a visual in isolation, I don't get errors, try to add them to more complex visuals i.e. tables with mulitple columns all heck breaks loose. Thanks!
rpiboy_1
2 years ago Place DAX Commands and Tips
683Views
0likes
2Comments
Error message for a measure - how to interpret it
Hi, I added a calculated table to my data with values for the previous year, and then tried to add a measure using Switch. This is what I wrote. Range PY = SWITCH(TRUE(),'Leads Amount PY'[Count of Leads PY]<3,"1-3",'Leads Amount PY'[Count of Leads PY]<5,"3-5",'Leads Amount PY'[Count of Leads PY]<10,"5-10") I get the following error message: A single value for column 'Count of Leads PY' in table 'Leads Amount PY' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result. The thing is I took the exact same steps for the current year, it works without a hitch and there is no aggregation there either. Is there another way to interpret this error message? What else can I check to make sure it works as intended?
Solved
Berl21
3 years ago Place DAX Commands and Tips
786Views
0likes
3Comments