Forum Discussion
Display Competitors
Hi Guys,
I have a list of two columns.
| SKU | Category |
| Fruit | Apple |
| Fruit | Pineapple |
| Fruit | Strawberry |
| Vegetable | Carrot |
| Vegetable | Brinjal |
| Vegetable | Cauliflower |
I'm trying this:
- User Filters the SKU
- The sheet detects the parent category and lists out all the SKUs in that category
Example, if a user selects Apple, the sheet should list out:
| Item | KPI 1 | KPI 2 |
| Strawberry | Value | Value |
| Pineapple | Value | Value |
| Apple | Value | Value |
Looking for some guidance.
Thanks in advance!
Piyush
Hi PiyushBQ
According to your requirement, I suggest you add a measure to determine whether your selected category belongs to Fruit or Vegetable, and then use this measure to filter the table visual:
measure = VAR CA = VALUES(slicer[Category]) VAR SKU = CALCULATETABLE( VALUES('Table'[SKU]), FILTER(ALL('Table'),'Table'[Category] in CA)) RETURN IF(MAX('Table'[SKU]) in SKU,1,0)Please refer to the pbix file: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EVWD8lv5c09HvhlF_uT4PSIB5_M9K6m9MjVMFapTyTh5uQ?e=gr9swR
Best Regards,
Dedmon Dai
2 Replies
Hi PiyushBQ
According to your requirement, I suggest you add a measure to determine whether your selected category belongs to Fruit or Vegetable, and then use this measure to filter the table visual:
measure = VAR CA = VALUES(slicer[Category]) VAR SKU = CALCULATETABLE( VALUES('Table'[SKU]), FILTER(ALL('Table'),'Table'[Category] in CA)) RETURN IF(MAX('Table'[SKU]) in SKU,1,0)Please refer to the pbix file: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EVWD8lv5c09HvhlF_uT4PSIB5_M9K6m9MjVMFapTyTh5uQ?e=gr9swR
Best Regards,
Dedmon Dai
Hi,
Your explanation is completely out of sync. First you mention that the user selects a SKU and then you say "Example, if a user selects Apple"!!!!!!!
