Forum Discussion
TopN - Rows increase when adding a column
Thank you for your reply.
Unfourtunatly it does not work. I cannot add a column from another table with ADDCOLUMNS, I need to have a measure for the new column.
I fixed the issue by creating a new calculated table which is taking only the relevant columns for the calculations and grouping. Then, I created some measures for the calcualtions.
It's not an efficiendt way but it works (I was hoping to do everything in one measure by leveraging the VARIABLES)
Thank you for your reply.
Unfourtunatly it does not work. I cannot add a column from another table with ADDCOLUMNS, I need to have a measure for the new column.
I fixed the issue by creating a new calculated table which is taking only the relevant columns for the calculations and grouping. Then, I created some measures for the calcualtions.
It's not an efficiendt way but it works (I was hoping to do everything in one measure by leveraging the VARIABLES)