We have an analysis service cube contains:
1 Measure = All_Calls_Count
2 dimensions = Month & Call Status
The All_Calls_Count reflects the count of rows on the fact table as shown :
Is it possible to create another measure that count all rows with only Call_Status = Rejected ? How ?
The below picture shows the desired output when browsing the cube :
Best Answer
You can try:
In your case, it could look like that:
A more detailed example here.