Hi eazyBI,
I am building out an average risk rating report for our projects. I am looking calculate two separate risk ratings, the first is with all request types(dimension and property) included and the second is with one of the request types excluded from the calculation.
I have built out the fist rating successfully:
([Risk].[Low]*1
+
[Risk].[Moderate]*2
+
[Risk].[High]*3
+
[Risk].[Critical]*4)/[Status].[In Queue & In Progress]
My question is how do I duplicate this into a new measure and apply a filter to exclude the one request type from the calculation?
Thanks.