Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
Revised_Product Name =
IF( HASONEFILTER( Table[Product] ),
IF(
[Abs Variance] <= [Selected Variance Size],
"All Other",
SELECTEDVALUE( Table[Product] )
)
)
Best
D
Revised_Product Name =
IF( HASONEFILTER( Table[Product] ),
IF(
[Abs Variance] <= [Selected Variance Size],
"All Other",
SELECTEDVALUE( Table[Product] )
)
)
Best
D
Many thanks - this worked perfectly!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
75 | |
52 | |
46 | |
15 | |
12 |