topic Re: I need count as per the range defined in DAX Commands and Tips

I need count as per the range defined

imrangaslam — Mon, 18 Jan 2021 23:28:55 GMT

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

Re: I need count as per the range defined

Ashish_Mathur — Mon, 18 Jan 2021 23:42:21 GMT

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.

Re: I need count as per the range defined

imrangaslam — Mon, 18 Jan 2021 23:48:26 GMT

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

Re: I need count as per the range defined

Ashish_Mathur — Tue, 19 Jan 2021 00:13:43 GMT

Hi,

You may download my PBI file from here.

Hope this helps.

Re: I need count as per the range defined

imrangaslam — Tue, 19 Jan 2021 00:42:51 GMT

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.

😟

Re: I need count as per the range defined

Ashish_Mathur — Tue, 19 Jan 2021 01:40:07 GMT

Hi,

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

Re: I need count as per the range defined

imrangaslam — Thu, 21 Jan 2021 23:40:20 GMT

Thank Asihis for your solution.😎

Re: I need count as per the range defined

Ashish_Mathur — Fri, 22 Jan 2021 01:41:26 GMT

You are welcome.