Forum Discussion

kagu's avatar
kagu
Frequent Visitor
3 years ago
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", NAMEO...
Need Help
  • lbendlin's avatar
    lbendlin
    3 years ago

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

  • kagu's avatar
    kagu
    3 years ago

    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 

lbendlin's avatar
lbendlin
Super User
3 years ago

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

kagu's avatar
kagu
Frequent Visitor
3 years ago

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