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

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

want to see the result like this including 92.6% in Red color box expecting all the rows with % and in the end also the same like 

A   B  C

---------------

7    6  85.7%

4    3  75.0%

9    6  66.7%

5    3  60.0%

2    1  50.0%

0    6  00.0%

-----------------

27   25   92.6%

 

 

Thanks in advance.

Wickin's avatar
Wickin
Frequent Visitor
8 years ago

Not sure what result you're seeing currently.

Could you please add your PBIX file?

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    I am unable to attach here cn you pls share your email id so that i will share the .pbix file with you.