topic Re: Parameter fields options in DAX Commands and Tips

Parameter fields options

giogua0483 — Fri, 16 Feb 2024 14:48:35 GMT

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

Re: Parameter fields options

govindarajan_d — Sat, 17 Feb 2024 03:03:50 GMT

Hi giogua0483,

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

Re: Parameter fields options

giogua0483 — Sat, 17 Feb 2024 07:40:29 GMT

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?

Re: Parameter fields options

giogua0483 — Sat, 17 Feb 2024 12:11:38 GMT

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?