Forum Discussion

Khaoula_Farissi's avatar
Khaoula_Farissi
Frequent Visitor
5 years ago

dividing two measures

Hello this is my data Id BrandM1 BrandM2 Wave 1 A D w3 2 B D w2 3 C D w2 4 D C w2 5 A A w1 6 B B w2 7 C D w3 8 A C w3 9 B D w2 10 C...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Khaoula_Farissi , You can have measures like

M1 = divide(countrows(Table),calculate(countrows(Table), allexpect(Table, Table[wave])))

M2 = divide(countrows(Table),calculate(countrows(Table), allexpect(Table, Table[BrandM1])))

M3 = divide(countrows(Table),calculate(countrows(Table), allexpect(Table, Table[BrandM2])))

 

last table

 

measure 1 =
var M1 = divide(countrows(Table),calculate(countrows(Table), allexpect(Table, Table[wave])))
var M2 = divide(countrows(Table),calculate(countrows(Table), allexpect(Table, Table[BrandM1])))
return
divide(M1,M2)