Dear Team I have a table like thatBDG 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,37Material code201/01/2023 22.016,00 1.651,00 398.557,00MIXING 43.827,31 21,37Material 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? regardsmarco

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,

DAX Measure | Microsoft Fabric Community

Forum Discussion

Related content

DAX Measure

POWER BI DAX MEASURE

Dax measure help

DAX Calculated Measure

Help to create DAX Measure