Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Can we have this Dynamic instead of Hard code

Hi,

 

I have this code which is hard coded. I want to have it dynamic using DAX measure. 

 

Can this be done ?

 

Base UOM Highlights = Maxx( material,
IF(Material[Material group]="CORSF" || Material[Material group]="LBLTHT",
  IF(Material[Material type]="ZHWA",
      IF (Material[Base Unit of Measure]<>"EA" && Material[Base Unit of Measure]<>"ROL",1,2)),
IF(Material[Material group]="LBLTHT",
  IF(Material[Material type]="ZNBW",
     IF (Material[Base Unit of Measure]<>"EA" ,1,2))

Thanks in Advance!

 

Thanks,

Tejaswi

Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous 

    Not so clear about your criteria.

    I make a test but get a different result.

    Measure =
IF (
    (
        MAX ( Table1[Material group] ) IN { "CORSF", "LBLTHT" }
            && MAX ( Table1[Material type] ) = "ZHWA"
            && MAX ( Table1[Base UOM] ) = "EA"
    )                                              # your condition1 & 2
        || (
            MAX ( Table1[Material group] ) = "PKGCON"
                && MAX ( Table1[Material type] ) = "ZHWA"
                && MAX ( Table1[Base UOM] ) IN { "EA", "KIT", "SET", "KIT", "CV", "PK", "CAN" }
        ),                                            # your condition3
    2,
    1
)

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

5 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi parry2k ,

      Thanks for your reply!

       

      I want to use a list or array in my code. 

       

      I have these below conditions:

      -If Material Group is CORSF and Material Type is ZHWA then Base UOM should always be EA. ( if other than EA return me 1 else 2 )

      - If material Group is CORSF or LBLTHT and material type is ZHWA then Base UOM should always be EA.( if other than EA return me 1 else 2 )

      - If Material Group is PKGCON, and material Type is ZHWA, then base uom can be either EA, KIT,SET,KIT,CV,PK or CAN (if other than these return me 1 else 2)

       

      Here is the same sample data file in the dropbox link for your reference.

       

       

      https://www.dropbox.com/s/136eqpr04igfuqt/Sample%20data%201.xlsx?dl=0

       

       

       

      Appreaciate your help!

      Thanks,

      Tejaswi

       

       

       

       

      • v-juanli-msft's avatar
        v-juanli-msft
        Icon for Community Support rankCommunity Support
        7 years ago

        Hi Anonymous 

        Not so clear about your criteria.

        I make a test but get a different result.

        Measure =
IF (
    (
        MAX ( Table1[Material group] ) IN { "CORSF", "LBLTHT" }
            && MAX ( Table1[Material type] ) = "ZHWA"
            && MAX ( Table1[Base UOM] ) = "EA"
    )                                              # your condition1 & 2
        || (
            MAX ( Table1[Material group] ) = "PKGCON"
                && MAX ( Table1[Material type] ) = "ZHWA"
                && MAX ( Table1[Base UOM] ) IN { "EA", "KIT", "SET", "KIT", "CV", "PK", "CAN" }
        ),                                            # your condition3
    2,
    1
)

         

        Best Regards
        Maggie

         

        Community Support Team _ Maggie Li
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      parry2k ,

       

      Hi,

       

      Wondering if you had a chance to go thru this.

      Please let me know for any questions.

       

      Thanks,

      Tejaswi