Forum Discussion

MarcoMizz's avatar
MarcoMizz
Frequent Visitor
3 years ago
Solved

DAX Measure

Dear Team  I have a table like that BDG category Month  QTY   RRT   UNITS  Consumable_CCGruppo  ActualCost   WD  Material code1 01/01/2023      3.448,00    1.651,00    398.557,00 ...
  • 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,

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