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,

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?