How to change range of expression with 2 input box

[marjan_it]

Hi All

I have a chart that has a expression 'count(DISTINCT( if(FlowStatusID='19',MessageID)))'

I want to have 2 input box that define min and max .when  type min 0 and max 2 show the expression between 0 and 2. I defind variable but it does not work ok. 

this is my chart.

code	count
0000000000	1
0010090576	1
0010230823	1
0010272313	5
0010292187	3
0010330720	0
0010497684	4
0010577841	1
0010622799	1
0010647783	4
0010650474	3
0010704991	3
0010708340	0
0010729003	1
0010747214	0
0010756019	1

[rubenmarin]

Hi, it can be:
If(count(DISTINCT {<FlowStatusID={'19'}>} MessageID)>=S(varMinValue)
and count(DISTINCT {<FlowStatusID={'19'}>} MessageID)<=$(varMaxValue),
count(DISTINCT {<FlowStatusID={'19'}>} MessageID)
)

Or if you want to show allways the min and max values:
RangeMin(
RangeMax($(varMinValue), count(DISTINCT {<FlowStatusID={'19'}>} MessageID))
, $(varMaxValue))

You can also mix both, ie show all above min but capped at max:
If(count(DISTINCT {<FlowStatusID={'19'}>} MessageID)>=S(varMinValue)
RangeMin(count(DISTINCT {<FlowStatusID={'19'}>} MessageID)
, $(varMaxValue)))

[marjan_it]

No It dosent work correctly.
I found this code on the community Its work ok with just one dimension, but when we add more than one dimension it dose not work.
count(DISTINCT{$< [PersonNationalCode]={"=(count(DISTINCT( if(FlowStatusID='19',MessageID)))>= $(min)) and (count(DISTINCT( if(FlowStatusID='19',MessageID)))<= $(=max))"}>}if(FlowStatusID=19, MessageID))

[rubenmarin]

Probably the second dimension is messing with the expression but it's hard to know without a look to model or at least wich dimensions are used.
Can you upload a sample?

[marjan_it]

No I cant upload my real sample. but I want to make a chart with for example 3 dimensions like below table and the expression is this condition in the "count(distinct (if (FlowStatusID=19,MessageID)))" range of input box

[rubenmarin]

This table doesn't have FlowStatusID or MessageID and the issue most probably is caused becuase of the relation wirth the dimensions and this values.

Usually one solution when something works with one dimension and not with many it can be use an aggr(), wich can impact performance:

Sum(Aggr(count(DISTINCT{$< [PersonNationalCode]={"=(count(DISTINCT( if(FlowStatusID='19',MessageID)))>= $(min)) and (count(DISTINCT( if(FlowStatusID='19',MessageID)))<= $(=max))"}>}if(FlowStatusID=19, MessageID)), [Dim1],[Dim2],[Dim3]))