cancel
Showing results for
Did you mean:
Frequent Visitor

## Multiplication or division of two measures

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.

1 ACCEPTED SOLUTION
Super User II

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!

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, and Sales Analysis Report
4 REPLIES 4
Frequent Visitor

Thank you both for your help.

Both solutions worked.

Community Support

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

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super User IV

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

Proud to be a Super User!

Super User II

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!

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, and Sales Analysis Report

Announcements

#### 2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.