Forum Discussion

giogua0483's avatar
giogua0483
Frequent Visitor
2 years ago

Parameter fields options

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

3 Replies

  • giogua0483's avatar
    giogua0483
    Frequent Visitor
    2 years ago
    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?
  • giogua0483's avatar
    giogua0483
    Frequent Visitor
    2 years ago

    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?