cancel
Showing results for
Did you mean:
Helper V

## divide two measures errors.

Hi,

I want to divide Measure 1 by Measure 2 --> Measure 1 / Measure 2.

Further information - Measure 1 = 687

- Measure 2 = 988

I get as a result : 49,59% while it should be 69,53%

Measure 1:

Act_Current_Qrt = CALCULATE(COUNTX(NDPd_Raw_Data,NDPd_Raw_Data[Date]),
FILTER(NDPd_Raw_Data,NDPd_Raw_Data[Year]=YEAR(TODAY())),
Filter(NDPd_Raw_Data, NDPd_Raw_Data[Act./Fct.]= "NDPd_Actual"),
Filter(NDPd_Raw_Data, NDPd_Raw_Data[Month]="P04"))
+
CALCULATE(countx(NDPd_Raw_Data,NDPd_Raw_Data[Date]),
FILTER(NDPd_Raw_Data,NDPd_Raw_Data[Year]=YEAR(TODAY())),
Filter(NDPd_Raw_Data, NDPd_Raw_Data[Act./Fct.]= "NDPd_Actual"),
Filter(NDPd_Raw_Data, NDPd_Raw_Data[Month]="P05"))
+
CALCULATE(sumx('CT Fct','CT Fct'[Data]),
Filter('CT Fct', 'CT Fct'[Month]="P06"))

Measure 2:
Fct_Current_Qrt =
CALCULATE(sumx('CT Fct','CT Fct'[Data]),
Filter('CT Fct', 'CT Fct'[Qx]="Q2"))

Br,

6 REPLIES 6
Community Support

You can try to use Var to make variables

``````divide =
var _1=[Act_Current_Qtr]
var _2=[Current_Qtr_Progres]
return
DIVIDE(_1,_2)``````

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Super User III

Hi,

Are the 687 and 988 results being returned by the 2 measures correct?  If yes, then ensure that there are no additioal filter/slicers on that visual/page/report.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Helper V

Hello,

please find below the snapshot of the PBI report and the % i'm getting is wrong.

Super User III

There's no way i can help you/find out the error with a screenshot.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Super User III

Are you sure Measure 1 and Measure 2 are returning the result that you expect and show above? I bet they aren't. If they were, the division should be straightforward and certainly yield the correct result.

Share the pbix if possible

 Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Helper V

Hi,

please find below the snapshots of the 2 measures as well as the graph. you will notice that the % in the graph is wrong. i don't know why.

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.

#### Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

#### Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Top Kudoed Authors