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

Count of duplicate processes in fact table

Updated May 21, 2018 20:06 PM

Data Warehouse indexing approach - to verify

Updated November 08, 2016 08:02 AM

SSAS memory usage

Updated November 27, 2017 16:06 PM