Forum Discussion

madscientist's avatar
madscientist
Frequent Visitor
6 years ago
Solved

Creating a dimension based on measures

Greetings,   I currently have a list of products with associated measures - see example below:   Product        Actual          Budget        Variance         Abs Variance A                  100...
  • Anonymous's avatar
    Anonymous
    6 years ago
    Revised_Product Name =
IF( HASONEFILTER( Table[Product] ),
	IF(
	    [Abs Variance] <= [Selected Variance Size],
	    "All Other",
	    SELECTEDVALUE( Table[Product] )
	)
)

    Best

    D

  • madscientist's avatar
    madscientist
    6 years ago

    Many thanks - this worked perfectly!

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Revised_Product Name =
IF( HASONEFILTER( Table[Product] ),
	IF(
	    [Abs Variance] <= [Selected Variance Size],
	    "All Other",
	    SELECTEDVALUE( Table[Product] )
	)
)

Best

D