SSAS Cube - Create measure based on the a dimension attribute We have an analysis service cube contains:

1 Measure = All_Calls_Count

2 dimensions = Month  &amp;  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 :
You can try:


create a Calculated Member (clic on Calculation tab and then on
New Calculated Member 
define it with the MDX expression you want


In your case, it could look like that:


A more detailed example here.