Creating a dimension based on measures

[madscientist]

Greetings,

I currently have a list of products with associated measures - see example below:

Product        Actual          Budget        Variance         Abs Variance

A                  100               90               +10                 10

B                  200               250              (50)                 50

C                  150               175              (25)                 25

I created a measure that allows me to aggregate the products based on the size of variance (selected in a separate slicer).  Based on that selection, I want to create a new dimension of the product names.  For example, if a project has a absolute value variance > 30, what I'd like to see is:

Product        Actual          Budget        Variance       Abs Variance      Revised_Product Name

A                  100               90               +10              10                       All Other

B                  200               250              (50)              50                       B

C                  150               175              (25)              25                       All Other

I am not sure why the following syntax doesn't work.  When I write the formula, I am not able to "call up" the column of product names:

Revised_Product Name = SWITCH (

                                                   TRUE( ),

                                                       [Abs Variance] <= [Selected Variance Size], "All Other",

                                                       'Table'Product

                                                         )

Thanks for any insights.

[Anonymous · Accepted solution]

Revised_Product Name =
IF( HASONEFILTER( Table[Product] ),
	IF(
	    [Abs Variance] <= [Selected Variance Size],
	    "All Other",
	    SELECTEDVALUE( Table[Product] )
	)
)

Best

D

[Anonymous · Accepted solution]

Revised_Product Name =
IF( HASONEFILTER( Table[Product] ),
	IF(
	    [Abs Variance] <= [Selected Variance Size],
	    "All Other",
	    SELECTEDVALUE( Table[Product] )
	)
)

Best

D

[madscientist · Accepted solution]

Many thanks - this worked perfectly!