Forum Discussion

emmanuelkamara1's avatar
emmanuelkamara1
Helper I
6 years ago
Solved

Need help

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.
 

Need Help DAX measure
  • Pragati11's avatar
    Pragati11
    6 years ago

    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

     

2 Replies

  • Pragati11's avatar
    Pragati11
    Super User
    6 years ago

    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