Forum Discussion
PiyushBQ
Helper I
Helper IShow Peer Group
Hi Guys, I have a list of two columns. Category SKU Fruit Apple Fruit Pineapple Fruit Strawberry Vegetable Carrot Vegetable Brinjal Vegetable Cauliflower ...
Here's a solution based on Many2Many (higher granularities).
https://1drv.ms/u/s!ApyQEauTSLtOgYJUerVJHKwk6ECH9Q?e=7D1Ktr
The last one based on Virtual Relationships is in the making...
Best
D
Greg_Deckler
Community Champion
Community ChampionPerhaps:
Measure =
VAR __SKU = SELECTEDVALUE('Table'[SKU])
VAR __Category = MAX('Table'[Category])
VAR __Table = FILTER(ALL('Table'),'Table'[Category] = __Category)
RETURN
CONCATENATEX(__Table,[SKU],",")PBIX attached.
PiyushBQHelper I
Helper IThank you for taking the time out, Greg.
This works!
Can you please guide on structuring the layout?
An output in the matrix table would be ideal. That'll allow me to display KPIs for the rivals
Example:
| Item | KPI 1 | KPI 2 |
| Strawberry | Value | Value |
| Pineapple | Value | Value |
| Apple | Value | Value |
Again, thanks heaps!