Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

desktop

Hi,   i am facing an issue with dax, i have written a if condition to create a new column. need a support to fix this problem asap. i am explaining the issue with dummy data, i have two columns li...
Need Help
  • Wickin's avatar
    Wickin
    8 years ago

    Try creating the following measure (not a column):

     

    C =
    DIVIDE ( SUM ( dummy[B] ), SUM ( dummy[A] ), 0 )
  • jthomson's avatar
    jthomson
    8 years ago

    You had the result you wanted in your previous post...

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hello JThomson, while using "C = DIVIDE ( SUM ( dummy[B] ), SUM ( dummy[A] ), 0 )" formula i am getting the below result.

with sum on both the columns A, B.

 

 

 

 

 

 

 

 

 

 

 

if i apply don't summarise, getting below result

 

if i use the "C = IF(dummy[A] <> 0, (dummy[B]/dummy[A]), 0)" formula. getting the below results  but not able to get as 92.6% as totals under C column. If its fixed. then i am fine..As per the client requiremnt,  if A is not equals to 0 then B/A else 0.

Have almost 30 million records are there thats why explainin my senorio with dummy data.

i have taken the Table as visual and if i get the value 92.6% in first ed box with all the rows. Then my met my requirment.

Thanks

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi JThomson/Wickin ...kindly help on the below to sort out. Thanks in advance

  • jthomson's avatar
    jthomson
    Solution Sage
    8 years ago

    You had the result you wanted in your previous post...