Forum Discussion
Solved
Control Field Parameters with Related Table?
Simple Version: Essentially, I want to use a related custom table, to filter the field parameter tables in order to build a chart with a custom Y and X axis using predefined styles. Have one Fi...
Hi DavidKuhry ,
You can try to use measure to achieve the effect.
1. Create a calculation sheet.Table = GENERATE(SELECTCOLUMNS('Table1',"Value1",'Table1'[Value],"Order1",'Table1'[Order]),SELECTCOLUMNS('Table2',"Value2",'Table2'[Value], "Order2",'Table2'[Order]))
2. Create measure.Measure = VAR _value1 = SELECTEDVALUE('Table'[Value1]) VAR _value2 = SELECTEDVALUE('Table'[Value2]) RETURN SWITCH( TRUE(), _value1="Value 1.a"&&_value2="Value 2.a","Custom1", _value1="Value 1.a"&&_value2="Value 2.b","Custom2", _value1="Value 1.b"&&_value2="Value 2.c","Custom3" )If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi DavidKuhry ,
You can try to use measure to achieve the effect.
1. Create a calculation sheet.
Table = GENERATE(SELECTCOLUMNS('Table1',"Value1",'Table1'[Value],"Order1",'Table1'[Order]),SELECTCOLUMNS('Table2',"Value2",'Table2'[Value], "Order2",'Table2'[Order]))
2. Create measure.
Measure =
VAR _value1 = SELECTEDVALUE('Table'[Value1])
VAR _value2 = SELECTEDVALUE('Table'[Value2])
RETURN
SWITCH(
TRUE(),
_value1="Value 1.a"&&_value2="Value 2.a","Custom1",
_value1="Value 1.a"&&_value2="Value 2.b","Custom2",
_value1="Value 1.b"&&_value2="Value 2.c","Custom3"
)
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.