topic Re: Creating a Measure from a Dimension in Reporting Service & Alerting

Creating a Measure from a Dimension

Goodman_UPS — Tue, 07 May 2024 13:20:15 GMT

I have a dimension that I created called Proposed Bucket.

Here is my if statement:

=If(Excp_Category='6-Attempted','2-CUSTOMER ACTION',

if(Excp_Category = '1-Manifest','5-APPLE ACTION',

If(Excp_Category='5-Out for Delivery','3-OUT FOR DELIVERY',

if(Current_Scan_Activity_Record_Type='Out For Delivery','3-OUT FOR DELIVERY',

IF(Excp_Category='7-Delivery','1-DELIVERED', [Exception_Resolution_Proposed_Bucket])))))

I want to create a measure that adds up certain elements of this proposed bucket.

BrunPierre — Wed, 08 May 2024 07:09:04 GMT

Sum({$<[Proposed Bucket]={'2-CUSTOMER ACTION','1-DELIVERED'}>} Measure)

Goodman_UPS — Wed, 08 May 2024 14:13:56 GMT

I get error in expression when used.

BrunPierre — Wed, 08 May 2024 14:50:26 GMT

It was simply an example that needed to be adjusted to reflect field names in the model.

Perhaps you could post a sample of the dataset.