Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Jogi
Contributor III
Contributor III

Selected field unexpected multiple value in chart

Hello guys, i experienced problem when i selected value in filter, data in chart going high, instead of going down, do you know what may cause a problem? 

nummax(0,sum({<Type={'Current'}, [Age on Claim] = {1}>}[Total Claim Payment])
/
count({<Type={'Current'},[In service]={1}, ScopeText=, Description=, [Age on Claim] =, %FunctionKey=, [Module Team-Description]= ,
[Area]=, [Module Team]=, [Model Family]=>} DIM))

 

 

 

 

 

Labels (2)
1 Solution

Accepted Solutions
Jogi
Contributor III
Contributor III
Author

Just remove column name from function just like filter=, resolve the problem 

View solution in original post

5 Replies
sunny_talwar

Which filter are you selecting the value in? Are you able to share a sample where we can see the issue?

Jogi
Contributor III
Contributor III
Author

Yeah, sure when i select  value in filter, list box   

clipboard_image_0.png

value goes high: 

 

 

clipboard_image_4.png

Maybe you have any idea what to check, or where to start, because i checked tables, connection and everything looks good calculation works, besides that filter when i selected value unexpected value appear looks like it get multiple by some value 

sunny_talwar

This doesn't really help... are you able to share a qvw sample to look at?

Jogi
Contributor III
Contributor III
Author

Yes, can i send you via link using onedrive, because file is huge > 120 MB
Jogi
Contributor III
Contributor III
Author

Just remove column name from function just like filter=, resolve the problem