Forum Discussion

sajidmansoorali's avatar
8 years ago

DAX table reference without affecting others measures and calculated tables

i have been working on a sales dashboard, now this dashboard have 150 plus measures and 15 plus report pages.

by mistake, I created a new table Sales from existing table SalesCurrent by this way.

Sales = SalesCurrent

 

And now all my tables and measures are referenced with this Table named as Sales. This is making Data Model size to double. Now I want to remove this “Sales=SalesCurrent” and want to update all measures to be refrenced with  SalesCurrent table directly instead of Sales.

 

Note I have also created calculated columns on Sales.

 

Can anybody help me, Please.