Forum Discussion
cannot specify column name without aggregation
I have used Left() function to retreive left most characters
sheetalshettiga
When you use a measure, you cannot access a value/column directly, it has to be covered by a function. If you are adding a column in a table then it is possible to directly refer without such functions as you are in a row context. This also applies when you use iteration functions such as SUMX, MAXX, and so on.
Hope it made it clear?________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
3 Replies
sheetalshettiga
When you use a measure, you cannot access a value/column directly, it has to be covered by a function. If you are adding a column in a table then it is possible to directly refer without such functions as you are in a row context. This also applies when you use iteration functions such as SUMX, MAXX, and so on.
Hope it made it clear?________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
So what aggregation should I use while referring to any column in any of the dax functions ? Fowmy
sheetalshettiga
You can use MAX or SELECTEDVALUE________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
