Please help.

[emmanuelkamara1]

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]

yeah, just create and conditional column with the following criteria 

[emmanuelkamara1]

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

[Anonymous · Accepted solution]

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?