Forum Discussion
Self Referencing CALCULATEDTABLE()
I have the following calcualted table: Customer First Medium =
SELECTCOLUMNS(
CALCULATETABLE(
'Opportunity Description',
'Opportunity Description'[Found in GA] = "Found"
),
"Order...
Hi maracles
According to your description, you want to add a rank column into your calculated table. Right?
In DAX, ADDCOLUMNS() function will return a new table contains original column and add columns. This is based on a created table. But we can't generate this calculated table with rank column through one DAX, it's not possible to achieve this "Self Referencing". Because when revolving the RANKX() function, the table is not created completely yet, however this rank column is also a part of table, it is running into paradox. So for your requirement, since you have generated the calcualted table first, you can do modeling on your dataset and add calculated column with RANKX() function populated.