Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Hi,
I have maintanted the 2 original tables intact. Your Customer can edit the ranges of Table2. Please review my solution again.
Thank Asihis for your solution.😎
You are welcome.
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.
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
Hi,
You may download my PBI file from here.
Hope this helps.
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.
😟
Hi,
I have maintanted the 2 original tables intact. Your Customer can edit the ranges of Table2. Please review my solution again.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
16 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |