Forum Discussion

GilbertGotfried's avatar
GilbertGotfried
Frequent Visitor
4 months ago
Solved

Calculating a total in one step with assessing multiple rows at the same time

I have data that looks like this.  Customers can get multiple ratings. If at least one of those ratings fulfills the logic, that customer is counted once as being positively rated.  I'm not counting ...
Need Help
  • cengizhanarslan's avatar
    cengizhanarslan
    4 months ago

    Please try the measure below:

    Customers with Positive Rating =
CALCULATE (
    DISTINCTCOUNT ( Table1[Customer ID] ),
    Table1[Rating] = "Good",
    Table1[Risk] IN { "Moderate Risk", "High Risk" }
)
mickey64's avatar
mickey64
Icon for Super User rankSuper User
4 months ago

For your reference.

Step 0: I use these data below.

 

Step 1: I make a measure and a matrix below.

Count = CALCULATE(DISTINCTCOUNT('DATA'[Customer ID]),FILTER('DATA',([Rating]="Good"&&[Risk]="Moderate Risk")||([Rating]="Good" && [Risk]= "High Risk")))