Forum Discussion

clem312's avatar
clem312
Resolver I
5 years ago
Solved

Matrix ?

Hi,   I need to built a strange matrix : For each brand, the top 5 items and the percentage associated for that item order by DESC I have no idea how to built that with Power BI visualisation gra...
Need Help
  • clem312's avatar
    clem312
    5 years ago

    Excellent, thank you Amit !

amitchandak's avatar
amitchandak
Super User
5 years ago

clem312 , Create rank , assume you have percentage measure

 

Rank = rankx(filter(allselcted(Table[Brand], Table[Item]), [Brand] =max([Brand]),[percentage],,desc, dense)

 

Create a new series 

RankT = generateseries(1,5,1)

 

Now use this column from RankT on rows of matrix and band on column

 

Try measures like

 

maxx(Filter(addcolumns(Summarize(Table, Table[Brand], Table[Item]), "_1", [percentage], "_2", [Rank]), [_2] =max(RankT[Value])), [Item])

 

refer if needed

 

Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1387187#M626


Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k


maxx(Filter(addcolumns(Summarize(Table, Table[Brand], Table[Item]), "_1", [percentage], "_2", [Rank]), [_2] =max(RankT[Value])), [percentage])

 

remove null rankT values or Rank > 5

  • clem312's avatar
    clem312
    Resolver I
    5 years ago

    Excellent, thank you Amit !

  • clem312's avatar
    clem312
    Resolver I
    5 years ago

    Hi Amit,

     

    However, I am not able to display the percentage new to the items as in the table I posted. The items are nicely ordered by their rank but the percentage become totally wrong.

    Any idea ?