Field paramters: two different dimensions

[kagu]

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.

[lbendlin · Accepted solution]

Then adjust your Parmeters accordingly, without mixing fiscal years and product types.

[lbendlin]

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)
}

[kagu]

Yes. But I do want two slicers. One for FY23/FY24 and one for Volume/Value.

[lbendlin · Accepted solution]

Then adjust your Parmeters accordingly, without mixing fiscal years and product types.

[kagu · Accepted solution]

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