Display Competitors

[PiyushBQ]

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

[Ashish_Mathur]

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"!!!!!!!

[v-deddai1-msft · Accepted solution]

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_u...

Best Regards,

Dedmon Dai