Forum Discussion

emmanuelkamara1's avatar
emmanuelkamara1
Icon for Helper I rankHelper 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? somethi...
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

     

Pragati11's avatar
Pragati11
Icon for Super User rankSuper 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

 

  • emmanuelkamara1's avatar
    emmanuelkamara1
    Icon for Helper I rankHelper I
    6 years ago

    Thanks a lot!