Forum Discussion

arvindyadav's avatar
arvindyadav
Post Partisan
9 years ago
Solved

Added Measure Not Working.

Hi All,

 

When I reload my data after 2- 3 days the added measure value can't response .

Please help me out from this query.

Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    9 years ago

    Hi arvindyadav,

     

    Please try to change the part in red color.

    Productive Calls =
CALCULATE ( DISTINCTCOUNT ( Query1[booked_order_id] ) )
    - CALCULATE (
        DISTINCTCOUNT ( 'Query1'[booked_order_id] ),
        'Query1'[booked_order_id] = 0
    )

    Best Regards!

    Dale

14 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    9 years ago

    Hi arvindyadav,

     

    Could you please post more information?

    1. What is the formula of the measure?

    2. What is the outcome of "can't response"? Did Power BI stop working? Or the measure returned a wrong result?

     

    If you can post a sample, that would be great. Some snapshots are also good.

     

    Best Regards!

    Dale

    • arvindyadav's avatar
      arvindyadav
      Post Partisan
      9 years ago

      1. What is the formula of the measure?

      Ans:- The Measure Formula is:-

      Measure =  CALCULATE(DISTINCTCOUNT(Query1[booked_order_id]))-CALCULATE(
      DISTINCTCOUNT('Query1'[booked_order_id]),
      'Query1'[booked_order_id] IN { 0 }

       

      2. What is the outcome of "can't response"? Did Power BI stop working? Or the measure returned a wrong result?case 

      Ans:- In initial it gives correct value when I publish in Power BI service it will gives same value but in somedaym 

      it  will give as disticnt count along with count of zero.

      Actually i don't want Zero count.

      • arvindyadav's avatar
        arvindyadav
        Post Partisan
        9 years ago

        This Report from Power BI desktop after adding Measures. and it showing correct productive calls i.e, In june 104.This Report from Power BI Service after publishing and refresh . and it showing wrong productive calls i.e, In june 105.

         

         

        Hi Dale ,

         

        Please Find the attached for your better reference.

        feel free to ask doubt regarding my issues.