Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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!
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
@adriankelly , Try like
division = divide([measure1],[measure2])
multiplication = SumX('Table 1','Table 1'[X]*'Table 1'[X]) * 'Parameter'[Value 2] * 'Parameter'[Value 1]
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |