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

darentengmfs's avatar
darentengmfs
Icon for Post Prodigy rankPost Prodigy
5 years ago

Hi rfwjr64 

 

The way I would approach this is creating a new column: $ Group = IF([Total EAU$] >2000, "More than $2,000","$2,000 or Less")

 

Then, put a pie chart in your report, under the Values field, put in the distinct ID you have for each row, e.g. SalesID and change the Count to Count Distinct, and put [$ Group] in the legends.