Forum Discussion
Solved
Field paramters: two different dimensions
Hi everyone,
I try to build an table, which is filterd by a field parameter.
Field_Act FY23 Val-Vol = {
("FY23", NAMEOF('Measures_Volume FY23'[Volume FY23]), 0),
("FY23", NAMEOF('Measures_Value FY23'[Value FY23]), 1)
}
This works really good.
Now I want to add additional the same two values from FY24 and want to add an extra filter. But I do not know how to combine it with my last one.
Thanks in advance for your help.
Then adjust your Parmeters accordingly, without mixing fiscal years and product types.
I tried this first with
Type = SWITCH(TRUE(), CONTAINSSTRING('Field_Val-Vol'[Val-Vol Felder],"Anzahl"), "Volume", "Value")and hat problems when there were tw row s with Volume or Value.
Now I added
Type Value = IF (CONTAINSSTRING(Parameter[Parameter Felder],"Anzahl")=True, "Volume", "Value")and it works
4 Replies
Your request is not clear. Do you want this?
Field_Act Val-Vol = { ("FY23 Volume", NAMEOF('Measures_Volume FY23'[Volume FY23]), 0), ("FY23 Value", NAMEOF('Measures_Value FY23'[Value FY23]), 1), ("FY24 Volume", NAMEOF('Measures_Volume FY24'[Volume FY24]), 2), ("FY24 Value", NAMEOF('Measures_Value FY24'[Value FY24]), 3) }