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

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.