Forum Discussion

Omega's avatar
Omega
Icon for Impactful Individual rankImpactful Individual
4 years ago
Solved

Remove tables names from measures

Hi,   Is there a way to remove all the table names from the measures when the measures are used within other measures, in one shot? I have like 50 measures and I am looking for a way to remove the ...
Need Help
Show and Tell
  • visheshjain's avatar
    visheshjain
    4 years ago

    Hi Omega,

     

    Not sure why you got the error, it should not be the case.

    A measure has nothing to do with the table it resides in, which is why it can be referenced without the table name.

     

    Try removing the table reference for the measure in the DAX, without moving the measure to a different table and see if it gives you an error.

     

    Just to confirm, you are using the latest Aug 2021 update, right?

     

    Thank you,

    Vishesh Jain

Omega's avatar
Omega
Icon for Impactful Individual rankImpactful Individual
4 years ago

That's my aim but the moment I did so, all my measures started giving me error because the measure moved to a new table. 

visheshjain's avatar
visheshjain
Icon for Impactful Individual rankImpactful Individual
4 years ago

Hi Omega,

 

Not sure why you got the error, it should not be the case.

A measure has nothing to do with the table it resides in, which is why it can be referenced without the table name.

 

Try removing the table reference for the measure in the DAX, without moving the measure to a different table and see if it gives you an error.

 

Just to confirm, you are using the latest Aug 2021 update, right?

 

Thank you,

Vishesh Jain