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

Hi @Dale,

 

Thank you very much....!!!

 

Its work :)

 

Regards,

Arvind

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

arvindyadav

 

Hi Arvind,

 

I am so glad your issue is resolved. Could you please mark it as answer? This would be a help to other community members. Thanks in advance.

 

Best Regards!

Dale

 

 

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

    arvindyadav,

     

    Hi Arvind,

     

    Yes, that's right! Thank you!

     

    Best Regards!

    Dale

  • arvindyadav's avatar
    arvindyadav
    Post Partisan
    9 years ago

    Hi @Dale,

     

    I have Accepted your formula as accept as solution which is same as the mask as answer?

     

    Regards ,

    Arvind

  • arvindyadav's avatar
    arvindyadav
    Post Partisan
    9 years ago

    Hi @Dale,

     

    My Pleasure :)

     

    Regards,

    Arvind