Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Calculate multiple columns

Hello Experts,   I am new to DAX queries. I am trying to calculate following fields, but unable to do so.   Column A Column B Column C Column D 85 39 30 21   my goal is to calcul...
Help Requested
Help required
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hello Ankit,

     

    Thanks for your response. I was able to derive accrurate figure based on the script mentioned below. Not sure why.

     

    Instead, i wrote below one and got the correct answer

     

    divide(Table[Column1] + Table[Column2] + Table[Column3], Table[Column4])

     

    regards

AnkitKukreja's avatar
AnkitKukreja
Icon for Super User rankSuper User
5 years ago

Hi Anonymous 

 

Please use this. I've shared the output below.

DIVIDE( SUMX( 'Table' , 'Table'[Column1] + 'Table'[Column2] + 'Table'[Column3] ) , 
        SUMX( 'Table' , 'Table'[Column4] ) )

 
Thanks,
Ankit Kukreja
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hello Ankit,

 

Thanks for your response. I was able to derive accrurate figure based on the script mentioned below. Not sure why.

 

Instead, i wrote below one and got the correct answer

 

divide(Table[Column1] + Table[Column2] + Table[Column3], Table[Column4])

 

regards