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,

 

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

arvindyadav's avatar
arvindyadav
Post Partisan
9 years ago

Hi @Dale,

 

It means Every day i have to publish my work into power BI service If this is right then there is no use of schedule refresh .

Or is there are any suggestion from your side that my measure value not affect by changing the date slicer.