Parameter fields options

[giogua0483]

I have in three parameter group that are linked in a matrix with Rows, Columns and Value a list of parameter to set.
One of these is the same for the three parameter.

Is possible to exclude the possibility to set more the one at the same time.

May share the DAX code?

Thank you in advance

Giovanni Guarino

[giogua0483]

More in detail I have created a measure that give me:
the value 0 if no one of the three parameter is selected
>= 2 if are selected a minimum of two.

If the value is > 2 I would like to modify this inside the parameter with DAX

"Imone", NAMEOF('GL_MES_KA_PMA'[Imones_Kodas]),0),

    ("Pardavimai Eur", NAMEOF('Calculations'[Pardavimai Eur]),1),

    ("Pardavimai kg", NAMEOF('Calculations'[Pardavimai kg]),2),

   

and delete the row
"Imone", NAMEOF('GL_MES_KA_PMA'[Imones_Kodas]),0),

It's possible?

[giogua0483]

FIRST GROUP OF PARAMETER

DimensijaA = {

    ("Imone", NAMEOF('GL_MES_KA_PMA'[Imones_Kodas]), 0),

    ("Pardavimai Eur", NAMEOF('Calculations'[Pardavimai Eur]), 1),

    }

SECOND GROUP OF PARAMETER

DimensijaY = {

    ("Imone", NAMEOF('GL_MES_KA_PMA'[Imones_Kodas]), 0),

    ("Metai", NAMEOF('GL_MES_KA_PMA'[OpMetai]), 1),

}
THIRTH GROUP OF PARAMETER

DimensijaZ = {

    ("Imone", NAMEOF('GL_MES_KA_PMA'[Imones_Kodas]), 0),

    ("Vadybininko", NAMEOF('GL_MES_KA_PMA'[RT_Vadybininko_Kodas_Vardas_Pavad]), 1),

}

I Would like that only one of the three parameter Įmonė could be selected.
This three groups are the ROW, COLUMN, and VALUE of a matrix and I want alternatively select only one of the parameter named Imone

SECOND OPTION
May I change using DAX the name of the Parameter group in ROW, COLUMN and VALUE?

[govindarajan_d]

Hi @giogua0483,

Can you explain in detail your requirements using some sample data?