SSAS Cube - Create measure based on the a dimension attribute

by Osama Waly   Last Updated May 11, 2017 12:06 PM

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 : Count of rows

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 : enter image description here

Related Questions

Data Warehouse indexing approach - to verify

Updated November 08, 2016 08:02 AM

SSAS memory usage

Updated November 27, 2017 16:06 PM

SSAS Feature to hold confidential data

Updated November 05, 2017 09:06 AM