Forum Discussion

Zakaria_1980's avatar
Zakaria_1980
Post Patron
5 years ago

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"))
 
thanks in advance.
Br,
 
Need Help

6 Replies

  • AlB's avatar
    AlB
    Community Champion
    5 years ago

    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's avatar
      Zakaria_1980
      Post Patron
      5 years ago

      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.

       

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    5 years ago

    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's avatar
      Zakaria_1980
      Post Patron
      5 years ago

      Hello,

       

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

      thanks for your support.

       

       

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        5 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.