Forum Discussion
Added Measure Not Working.
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
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
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
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
Hi @Dale,
Thank you very much....!!!
Its work :)
Regards,
Arvind
Hi @Dale,
I have Accepted your formula as accept as solution which is same as the mask as answer?
Regards ,
Arvind
Hi @Dale,
My Pleasure :)
Regards,
Arvind