Forum Discussion

sqzqsol's avatar
sqzqsol
New Member
3 years ago
Solved

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:

 

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.

 

Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    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.

1 Reply

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    3 years ago

    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.