Forum Discussion

emmanuelkamara1's avatar
6 years ago
Solved

Please help.

Emmanuel Kamara
I have a dax function that returns the total outstanding amount for values =1...and also a dax function that returns the sum of all the outstanding balance (0, and 1). What I want to do is to divide those two functions to get what I want (PAR= sum of outstanding balance for values=1/ sum of total outstanding balance. Or is there a way I could just get a column that contains only outstanding balance for values =1?
see screenshot below. 
  • Anonymous's avatar
    Anonymous
    6 years ago

    Sorry, you're not to type "outstanding balance", you need to change the output to "select a column", then select outstanding balance. 

     

    emmanuelkamara1 did that work for you? 

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    yeah, just create and conditional column with the following criteria 

     

    • emmanuelkamara1's avatar
      emmanuelkamara1
      Helper I

      Hi thanks! it only returns the name "outstanding_baance" and not the actual figure 

      • Anonymous's avatar
        Anonymous
        Not applicable

        Sorry, you're not to type "outstanding balance", you need to change the output to "select a column", then select outstanding balance. 

         

        emmanuelkamara1 did that work for you?