Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I am creating a new column using the following formula:
Hi, @Swastik79
try this one.
Calculated Column =
VAR Country = SELECTEDVALUE('Country Dimension'[Country])
VAR Plant = SELECTEDVALUE('Plant Dimension'[Plant])
RETURN
SWITCH(
TRUE(),
Country IN {"Country 1", "Country 2", "Country 3"}, "Value 1",
Country = "Country 4", "Value 2",
Country = "Country 5" && Plant IN {"Plant 1", "Plant 2", "Plant 3", "Plant 4"}, "Value 3",
Country = "Country 5" && Plant IN {"Plant 5", "Plant 6", "Plant 7"}, "Value 4",
"Others"
)
make sure to adjust column names.
Proud to be a Super User!
Hi @rubayatyasmin,
On using the above formula when i try to use calculated column as a row in a matrix it only shows "Others" as row. Can you edit the formula such that it displays "Value 1", "Value 2", "Value 3", "Value 4", "Others" as rows?
try this one.
Calculated Column =
VAR Country = SELECTEDVALUE('Country Dimension'[Country])
VAR Plant = SELECTEDVALUE('Plant Dimension'[Plant])
RETURN
SWITCH(
TRUE(),
Country IN {"Country 1", "Country 2", "Country 3"}, "Value 1",
Country = "Country 4", "Value 2",
Country = "Country 5" && Plant IN {"Plant 1", "Plant 2", "Plant 3", "Plant 4"}, "Value 3",
Country = "Country 5" && Plant IN {"Plant 5", "Plant 6", "Plant 7"}, "Value 4",
"Others"
) & "-" & Country
Proud to be a Super User!
Hi @rubayatyasmin,
On using the above formula when i try to use calculated column as a row in a matrix it now only shows "Others-" as row.
a demo data file would be appreciated.
Proud to be a Super User!
User | Count |
---|---|
85 | |
77 | |
72 | |
70 | |
55 |
User | Count |
---|---|
106 | |
96 | |
90 | |
79 | |
68 |