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" || Mat...
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.

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

Hi v-juanli-msft ,

 

This just worked as expected.

 

Many thnaks for the solutions!

 

Regardfs,

Tejaswi