Qs- Values reflecting

[Karahs]

Hello everyone,

So my question is that as seen in the below images the value in the cost column is reflecting while selecting some zone . The formula which i have used for Cost Column is :

(92000/(Count(Total{<[Final Status]={'Dispute','Not Contactable','Verified'},[Caller Type]={'CSO'}>}[Client Code])))*Count({<[Final Status]={'Dispute','Not Contactable','Verified'},[Caller Type]={'CSO'}>}[Client Code])

What should i do to not reflect the values? Is there any alternative way?

 

[sunny_talwar]

So you mean that value should not change based on selection in Zone Field? Try this may be

(92000/(Count(Total{<[Final Status]={'Dispute','Not Contactable','Verified'},[Caller Type]={'CSO'}, Zone>}[Client Code])))*Count({<[Final Status]={'Dispute','Not Contactable','Verified'},[Caller Type]={'CSO'}, Zone>}[Client Code])

[Karahs]

Hey,

It is kind of working, but it is affecting the totals column as u can see in the below image and Zone is not getting selected.

[sunny_talwar]

Not sure I follow the issue. What is wrong with Total? Extra rows?

[Karahs]

Hey ,

Can u find the difference in both the images?? When i select a specific zone it shows all the elemnts in that zone column, the selection which m doing is not getting specificaly selected.

[sunny_talwar · Accepted solution]

Try this:

(92000/(Count(Total{<[Final Status]={'Dispute','Not Contactable','Verified'},[Caller Type]={'CSO'}, Zone>}[Client Code])))*Count({<[Final Status]={'Dispute','Not Contactable','Verified'},[Caller Type]={'CSO'}>}[Client Code])

[Karahs]

Thankyou so much it worked