Forum Discussion
emmanuelkamara1
6 years agoHelper I
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.
- Anonymous6 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
- AnonymousNot applicable
yeah, just create and conditional column with the following criteria
- emmanuelkamara1Helper I
Hi thanks! it only returns the name "outstanding_baance" and not the actual figure
- AnonymousNot 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?