I have a list of two columns.
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 will list out:
I've tried this in my Power BI sheet but I'm unable to get this to work.
Looking for some guidance.
Thanks in advance!
Solved! Go to Solution.
Here's one way to do it:
Bet there's another based on virtual relationships. I'll place a link to a file with the other way in a sec... Most likely you don't want to concatenate. You want to display this in a table, in a visual, so the file above shows you how to do it.
Measure = VAR __SKU = SELECTEDVALUE('Table'[SKU]) VAR __Category = MAX('Table'[Category]) VAR __Table = FILTER(ALL('Table'),'Table'[Category] = __Category) RETURN CONCATENATEX(__Table,[SKU],",")
Thank you for taking the time out, Greg.
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
|Item||KPI 1||KPI 2|
Again, thanks heaps!
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!