Forum Discussion
Matrix Sorting Concatenated Calculated column by Max Value - Not working on Blank Product Names
In my fact table I have a calculated column called [Currency w/ Max Price] which simply take a measure called Max Price = MAX('table'[Selling Price]) and concatenates it to a column with Currency Typ...
Hi mpicca13 ,
Be aware that the use of measures in a calculated column returns incorrect results because of the row context.
A measure is evaluated in the context of the cell evaluated in a report or in a DAX query, whereas a calculated column is computed at the row level within the table it belongs to.
So you problably need to check the calculation that you have for the column because I believe you can have incorrect data in there.
Looking at the column you have probably you can use the same code to create a measure to use in your matrix visualization and get the result you need.