Forum Discussion
Helper IIIMeassure Returning Error that it refences to Column which it doesnt
Hi Guys,
I rly cant wrap my head around this but my meassure is giving me this error and i dont know why since it doesnt refference the wrong column.
Projection Values:
Type of Amount and Allocation Subset type are columns from the dataset.
Why do you think i am getting this error?
Thank you from writing I was able to fix the problem.
The Core/Sol/Trans column had switch function which used both integer and number therefore it wasnt performing as it should have. Not i corrected it and it works fine.
5 Replies
- AllisonKennedy
Community Champion
Question 1: What is column Data[Core/Sol/Trans] ? Is it DAX or power Query? If DAX, please share the formula, and any errors you get from it. If Power Query, was it calculated in Power Query? How?
Question 2: What are all the columns used in your Projection column? Do they come from the data directly or are they referencing other columns?
Question 3: When you did a Close & Apply on your data, did it return any errors in the query? If so, I want to see what those are. You can force this popup again by renaming one of the columns in your Data query in Power Query Editor, then click Close & Apply, and if it warns about errors please click "View Errors" and let us know what you see.
stanislav_dugasThank you from writing I was able to fix the problem.
The Core/Sol/Trans column had switch function which used both integer and number therefore it wasnt performing as it should have. Not i corrected it and it works fine.
- AllisonKennedy
stanislav_dugas Glad you sorted it out and that my questions were able to guide you in the right direction. Kudos are much appreciated. 🙂
- amitchandak
Super User
stanislav_dugas , Can you share a sample pbix after removing sensitive data.
- stanislav_dugas
Unfortunately all the data are sensitive. Anything else i could share to give a bit more insights?
