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...

jthomson's avatar
jthomson
Solution Sage
8 years ago

 

Anonymous wrote:

Thanks a lot Wickin for your quick response.

It's working but i tried this but i am expecting the result like row wise like below

 

Our formulas do that. You might need to turn off summarisation/turn on values with no data in your visual.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks a lot JThomson and Wickin for the resolution for my issue. It worked well.