Forum Discussion
maracles
Resolver II
Resolver IISelf Referencing CALCULATEDTABLE()
I have the following calcualted table: Customer First Medium =
SELECTCOLUMNS(
CALCULATETABLE(
'Opportunity Description',
'Opportunity Description'[Found in GA] = "Found"
),
"Order...
v-sihou-msft
Microsoft Employee
Microsoft EmployeeHi 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 Referencin​g". 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.