DAX Measure

[Prabha45]

Hi All,
I have a table as below. I need to write a dax like
Measure = Car(new)/(Bike(old)*Bicycle(new))

Product	Type	value
Car	New	25
Car	Old	10
Bike	New	20
Bike	Old	15
Bicycle	New	10
Bicycle	Old	20

Thankyou

[Dangar332 · Accepted solution]

Hi, @Prabha45 

tyr below measure 

just adjust your table and column name

Measure = 
var a= SUMX(FILTER('Table','Table'[product]="car"&&'Table'[Type]="new"),'Table'[value])
var b =SUMX(FILTER('Table','Table'[product]="bike"&&'Table'[Type]="old"),'Table'[value])
var c = SUMX(FILTER('Table','Table'[product]="bicycle"&&'Table'[Type]="new"),'Table'[value])
return 
DIVIDE(a,b*c)

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. and don't forget to give kudos.