Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Filter concatenated text by date slicer
11-25-2022
05:41 PM
Hi,
Power BI newbie. I wanted to know the top category by sales per place, per year so I created a calculated table with a calculated column for the rank that looks like this:
I tried to concatenate the categories for my visual using this measure:
Top Category = CONCATENATEX(FILTER(Table, Table[Rank]=1), Table[Category], ",")
But this is what I got despite the date on the slicer being Year 3:
I've been working on this for quite some time and can't seem to find any solution. I'd appreciate any help. Thanks in advance.
Solved! Go to Solution.
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-25-2022
07:21 PM

Hi,
These measures work
Sales = SUM(Data[Total sales])
Max sales = MAXX (VALUES(Data[Category]),[Sales])
Best selling category = CONCATENATEX(TOPN(1,VALUES(Data[Category]),[Sales]),Data[Category],",")
Hope this helps.
Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-25-2022
07:21 PM

Hi,
These measures work
Sales = SUM(Data[Total sales])
Max sales = MAXX (VALUES(Data[Category]),[Sales])
Best selling category = CONCATENATEX(TOPN(1,VALUES(Data[Category]),[Sales]),Data[Category],",")
Hope this helps.
Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources
Announcements
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Recommendations
Subject | Author | Posted | |
---|---|---|---|
02-12-2024 07:19 AM | |||
07-09-2024 01:42 AM | |||
05-20-2024 10:50 PM | |||
09-03-2021 01:20 PM | |||
05-24-2024 01:18 AM |
Featured Topics
Top Solution Authors (Last Month)
User | Count |
---|---|
87 | |
81 | |
53 | |
38 | |
35 |