Reply
sqzqsol
New Member
Partially syndicated - Outbound

Filter concatenated text by date slicer

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:

 

sqzqsol_0-1669426170363.png

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:

 

sqzqsol_1-1669426526675.png

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.

 

1 ACCEPTED SOLUTION
Ashish_Mathur
Super User
Super User

Syndicated - Outbound

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.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

1 REPLY 1
Ashish_Mathur
Super User
Super User

Syndicated - Outbound

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.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)