Forum Discussion

MarcoMizz's avatar
MarcoMizz
Frequent Visitor
3 years ago
Solved

DAX Measure

Dear Team 

I have a table like that

BDG categoryMonth QTY  RRT  UNITS Consumable_CCGruppo ActualCost  WD 
Material code101/01/2023     3.448,00   1.651,00   398.557,00MIXING   15.931,08   21,37
Material code201/01/2023   22.016,00   1.651,00   398.557,00MIXING   43.827,31   21,37
Material code301/01/2023   22.611,00   1.651,00   398.557,00MATERIAL PREPARATION   80.200,61   21,37

 

I need to create a DAX measure that based on the value of column "BDG category" make a specific calcutation, just for exmaple:

1 - in case "BDG category" is equal to "Material code1" the calculation should be "QTY" / "WD"

2 - in case  "BDG category" is equal to "Material code2" the calcualtion should be "QTY" / "UNITS"

3 - in case  "BDG category" is equal to "Material code3" the calcualtion should be "QTY" / "RRT"

 

can someone suggest to me the DAX measure to be used?

 

regards

marco

  • Alf94's avatar
    Alf94
    3 years ago

    Hi MarcoMizz ,

     

    I think you can use something like the following:

     

     

    Measure =
SWITCH(
    SELECTEDVALUE(Table[BDG Category]),
    "Material code1", DIVIDE(Sum(Table[Quantity]), Sum(Table[WD])),
    "Material code2", DIVIDE(Sum(Table[Quantity]), Sum(Table[UNITS])),
    "Material code3", DIVIDE(Sum(Table[Quantity]), Sum(Table[RRT]))
)

     

     

    If I answered your question, please mark my post as a solution.

     

    Best,

5 Replies

  • Alf94's avatar
    Alf94
    Solution Supplier
    3 years ago

    Hi MarcoMizz ,

     

    I think you can use something like the following:

     

     

    Measure =
SWITCH(
    SELECTEDVALUE(Table[BDG Category]),
    "Material code1", DIVIDE(Sum(Table[Quantity]), Sum(Table[WD])),
    "Material code2", DIVIDE(Sum(Table[Quantity]), Sum(Table[UNITS])),
    "Material code3", DIVIDE(Sum(Table[Quantity]), Sum(Table[RRT]))
)

     

     

    If I answered your question, please mark my post as a solution.

     

    Best,

    • MarcoMizz's avatar
      MarcoMizz
      Frequent Visitor
      3 years ago

      Hi Alf94,

      thanks for your replay, there is onething that I do not understand in your formula, what is "Table[BDG Category]" in you DAX expression?

      regards

      marco

      • Alf94's avatar
        Alf94
        Solution Supplier
        3 years ago

        BDG Category is your column's name. Did you try the measure?

  • MarcoMizz's avatar
    MarcoMizz
    Frequent Visitor
    3 years ago

    probably my request is not so clear.

    I have table A, the structure of this table is:

     

    I dont want to add a new column, I would like to build a DAX measure that on the value of column "BDG category"  make a specific calcutation, just for exmaple:

    1 - in case "BDG category" is equal to "Material code1" the calculation should be "QTY" / "WD"

    2 - in case  "BDG category" is equal to "Material code2" the calcualtion should be "QTY" / "UNITS"

    3 - in case  "BDG category" is equal to "Material code3" the calcualtion should be "QTY" / "RRT"

     

    regards

    marco