topic Re: Need help in DAX Commands and Tips

Need help

emmanuelkamara1 — Fri, 14 Aug 2020 16:45:42 GMT

How can I create a column that return outstanding values for only values =1? or how can I write a DAX function to devide the outstanding values for all (1's) and the total outstadning? something like this....outstanding value for (1's)/total outstanding value.

Re: Need help

Pragati11 — Fri, 14 Aug 2020 17:53:45 GMT

HI emmanuelkamara1 ,

You can try the following DAX expression by creating a measure:

CalcMeasure = DIVIDE(
CALCULATE(SUM(tablename[Outstanding_Balance]), tablename[30+_or_not] = 1), SUM(tablename[Outstanding_Balance]), 0
)

Replace tablename in above expression with your table name and also check column names.

Thanks,

Pragati

Re: Need help

emmanuelkamara1 — Fri, 14 Aug 2020 17:59:46 GMT

Thanks a lot!