Forum Discussion
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 ...
Please try the measure below:
Customers with Positive Rating = CALCULATE ( DISTINCTCOUNT ( Table1[Customer ID] ), Table1[Rating] = "Good", Table1[Risk] IN { "Moderate Risk", "High Risk" } )
Ashish_Mathur
Super User
Super UserHi,
Please share data in a format that can be pasted in an MS Excel file.