Meassure Returning Error that it refences to Column which it doesnt

[stanislav_dugas]

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?

[AllisonKennedy]

@stanislav_dugas 

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_dugas · Accepted solution]

Hi @AllisonKennedy 

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.

[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]

@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?