Forum Discussion

jurgenvd's avatar
jurgenvd
Helper I
8 years ago
Solved

Quick measure percentage difference shows incorrect value

Hi all

 

i have a quick measure that divides the "Incidents closed" by the Opened incidents and it should show me the closure rate.

 

For 1 row it is correct but for another row it gives wrong value.

 

my measure is 

 

incidents Closure rate = 
1 - (VAR __BASELINE_VALUE = [Incidents closed]
VAR __VALUE_TO_COMPARE = [Incidents opened]
RETURN
	IF(
		NOT ISBLANK(__VALUE_TO_COMPARE);
		DIVIDE(__VALUE_TO_COMPARE - __BASELINE_VALUE; __BASELINE_VALUE)
	))

 my outcome you can find below.


What is the reason why week 4 shows wrong figures?

 


Thanks

 

 

Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi jurgenvd,

     

    If you directly add this measure to visual, does it return correct results?

    Percentage=DIVIDE([Incidents closed],[Incidents opened])

    Above formula is generated automatically via Quick measure, right? Please manually create a measure with the same DAX code to test whether it can display expected result.

     

    Regards,

    Yuliana Gu

2 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi jurgenvd,

     

    If you directly add this measure to visual, does it return correct results?

    Percentage=DIVIDE([Incidents closed],[Incidents opened])

    Above formula is generated automatically via Quick measure, right? Please manually create a measure with the same DAX code to test whether it can display expected result.

     

    Regards,

    Yuliana Gu

    • jurgenvd's avatar
      jurgenvd
      Helper I
      8 years ago

      hi  v-yulgu-msft

       

      It's working! Thank you so much.


      No idea why the quick measures gives a wrong calculation.

       

      Thanks again !!