divide two measures errors.

[Zakaria_1980]

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"))

thanks in advance.

Br,

[Anonymous]

Hi  @Zakaria_1980  ,

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.

[Ashish_Mathur]

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.

[Zakaria_1980]

Hello,

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

thanks for your support.

[Ashish_Mathur]

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

[AlB]

Hi @Zakaria_1980 

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.

[Zakaria_1980]

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.