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 t...
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.

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.