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,

 

Please Find the attached .

Its not based on date slicer .

Even on the date of 11th july it fluctuating june productve calls.

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

Hi arvindyadav,

 

1. The outcome of the formula below could be 1 or blank. What is the real value in your table, 0 or blank?

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

2. Your formula is equivalent with this one, Please have a try.

Measure =
CALCULATE (
    DISTINCTCOUNT ( Query1[booked_order_id] ),
    'Query1'[booked_order_id] <> 0
)

EDIT: These two formulas are not equivalent. Please try the new one.

 

Best Regards!

Dale

  • arvindyadav's avatar
    arvindyadav
    Post Partisan
    9 years ago

    Hi @Dale,

     

    The Mine formula i.e, 

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

    DISTINCTCOUNT('Query1'[booked_order_id]),

    'Query1'[booked_order_id] IN { 0 }

    )

    Give me the value excluding zero.

     

     

    1. The outcome of the formula below is 0.

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

     So from total distinct count of book order id I have count every value excluding Zero so that is the why I am using the formula

     

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

    DISTINCTCOUNT('Query1'[booked_order_id]),

    'Query1'[booked_order_id] IN { 0 }

     

    which give me distinct count excluding zero.

     

    Please feel free to ask if you have still any doubt regarding that.

     

    Regards ,

    Arvind

     

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Microsoft Employee
      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