Multiplication or division of two measures

[adriankelly]

Hi,

I have two measures calculated from a data column and what if parameters. 

These are:

Measure 1 = Sum('Table 1'[X]) * 'Parameter'[Value 1]

Measure 2 = Sum('Table 1'[X]) * 'Parameter'[Value 2]

With this the output is both a sum value and row context values displayed in visuals.

My question is , is it possible to multiply/divide measure 1 x measure 2 and get the same output.

It works for addition or subtraction of the two measures but not multiplication or division.

When multiplying the result is blank and when dividing the result is infinity. 

[adriankelly]

Thank you both for your help.

Both solutions worked.

[Anonymous]

Hi @adriankelly ,

If the problem has been resolved, could you please mark the helpful post as Answered? It will help others in the community find the solution easily when they face the same problem with you. Thank you.

Best Regards

Rena

[amitchandak]

@adriankelly , Try like

division = divide([measure1],[measure2])
multiplication = SumX('Table 1','Table 1'[X]*'Table 1'[X]) * 'Parameter'[Value 2] * 'Parameter'[Value 1]

[Tahreem24 · Accepted solution]

@adriankelly ,

Yup, you can divide the and multiply the two measures:

Measure 3 = IFERROR((Measure1 * Measure2),"-")

Measure 4  = IFERROR((Measure1 / Measure2),"-")

I would really appreaciate your THUMBS UP for support!