Forum Discussion

rfwjr64's avatar
rfwjr64
Frequent Visitor
6 years ago
Solved

Dividing

Hello, I am trying to divide a subset of values in one column by the total of the same column.   What I am trying to determine is how many records have an EAU$ of less than $2000 and divide that numb...
Need Help
  • Pragati11's avatar
    Pragati11
    6 years ago

    Hello @rfwjr64 ,

    You can create a measure as follows:

    calcMeasure - DIVIDE(
    CALCULATE(DISTINCTCOUNT(tablename[EAU$]), tablename[EAU$] < 2000),
    DISTINCTCOUNT(table name[EAU$]), 0)

    Use the table name and column name in the previous DAX expression.

    Thank you

    Pragati

Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
6 years ago

Hello @rfwjr64 ,

You can create a measure as follows:

calcMeasure - DIVIDE(
CALCULATE(DISTINCTCOUNT(tablename[EAU$]), tablename[EAU$] < 2000),
DISTINCTCOUNT(table name[EAU$]), 0)

Use the table name and column name in the previous DAX expression.

Thank you

Pragati

rfwjr64's avatar
rfwjr64
Frequent Visitor
6 years ago

This does help. Now I can move on. Thank very much.