Forum Discussion

rfwjr64's avatar
rfwjr64
Frequent Visitor
5 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
    5 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

amitchandak's avatar
amitchandak
Super User
5 years ago

rfwjr64 , Try a new measure like

divide(calculate(distinctcount(Table[Column), filter(Table, Table[EAU]<2000)),distinctcount(Table[Column))