cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
adriankelly
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
Tahreem24
Super User II
Super User II

@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!

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

View solution in original post

4 REPLIES 4
adriankelly
Frequent Visitor

Thank you both for your help.

Both solutions worked.

 

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

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.
amitchandak
Super User IV
Super User IV

@adriankelly , Try like

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Tahreem24
Super User II
Super User II

@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!

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

View solution in original post

Helpful resources

Announcements
MBAS on Demand

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.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Urdu Hindi D365 Bootcamp 768x460.png

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Top Solution Authors
Top Kudoed Authors