I need count as per the range defined

[imrangaslam]

Hello

I have two tables

Table 1

Start Time	Product	Category	Unit
1/8/2018 8:38	CEM I 52.5 R	SETINI_AVG	29.4
1/12/2018 7:47	CEM I 52.5 R	SETINI_AVG	29.4
1/15/2018 7:49	CEM I 52.5 R	SETINI_AVG	29
1/17/2018 9:46	CEM I 52.5 R	SETINI_AVG	30.7
1/19/2018 10:40	CEM I 52.5 R	SETINI_AVG	23.4
1/22/2018 9:41	CEM I 52.5 R	SETINI_AVG	28.1
1/24/2018 8:51	CEM I 52.5 R	TZ.600.BU.2W	28.2
1/29/2018 9:28	CEM I 52.5 R	TZ.600.BU.2W	26.7

Table 2

ProductID	ProductCategory	RedMinVal	RedMaxVal
CEM I 52.5 R	SETINI_AVG	110	170
CEM I 52.5 R	1CSA	24	30
CEM I 52.5 R	2CSA	35	41
CEM I 52.5 R	28CSA	60	66
CEM I 42.5 R	SETINI_AVG	120	180
CEM I 42.5 R	1CSA	15	21

I am looking to count the no. of record for Unit coloumn as per the below criteria

Product code: = CEM I 52.5 R

ProductCategory: = SETINI_AVG

Range as defined : 110 and 170

So I need to display in card result 6.

Any idea how to slove this.

Thanks you for all help

[imrangaslam]

Thank Asihis for your solution.😎

[Ashish_Mathur]

You are welcome.

[Ashish_Mathur]

Hi,

I do not understand.  In Table 2, the range is 110 to 170.  There is no figure in the unit column (for Category SETINI_AVG and Product CEM I 52.5 R) whcih is between 110 and 170.  I am confused.

[imrangaslam]

HI 

Thanks for  your reply.

I writed wrong. Appologize

As correct  as per below:

Product code: = CEM I 52.5 R

ProductCategory: = SETINI_AVG

Range as defined : 110 and 170 (range means I need to count all the record which are <= 110 and all the record which are >= 170)

So product CEM I 52.5 R and its category SETINI_AVG and in Unit we have top 6 record as per the our renge.

The count should be 6 so I can display in cart.

Thanks

[Ashish_Mathur]

Hi,

You may download my PBI file from here.

Hope this helps.

[imrangaslam]

Hi,

Many thank for your reply but I this solution will not help me as I can't put range in the detail table as range customer can update the ranges in table 2. So thats way I have sperate table for each product and its ranges. In table 1 we have transaction and need to check range in table.

😟

[Ashish_Mathur · Accepted solution]

Hi,

I have maintanted the 2 original tables intact.  Your Customer can edit the ranges of Table2.  Please review my solution again.