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

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.

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

        Hi arvindyadav,

         

        Did you notice that the slicer changed from "2017-07-10" to "2017-07-11" in the Service. Maybe this is the cause.

         

        Best Regards!

        Dale