Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Top 5 By Two different Conditions

Hi Everyone,   I have a set of data given below. Iwant top 5 assoicate name by spend as well by division. For example the division (Top5 would be in Column) and associate name would be in Rows in M...
Top N
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi Anonymous 

     

    I've attached a file with a solution.

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Everyone,

 

Adding one more situation in the given scenario. (I am using SQL server direct query source hence unable to add new tables in model)

 

I want to filter category first and then in the filter category I want fetch top 5 associate name and top 5 divison in that particulat category.

 

Below is the Raw data

 

CategoryAssociateDivisionSpend
BusinessA1Road234
AssetA2Services343
ElectriicalA1Home223
LabourA4Services555
BusinessA5Group4234
AssetA6Medical234
ElectriicalA7Music344
LabourA6Home2344
BusinessA9Vehicle434
AssetA6Hospital434
ElectriicalA11Class2
LabourA12Veg23434
BusinessA13Cream234
AssetA6Home2344
ElectriicalA9Vehicle434
LabourA6Hospital434

Asset

A11Class2

 

Result would be say I filtered Category using page level Filter as Asset. Therfore under asser Top5 supplier and Top 5 spend would be like below snapshot. Mine motive is to segereate the Associate name by category and under cateory which are the Top5 associate and their spend with Top5 division(In column in powerBi)

 

 

 

 

Kindly help I am struggling on this from last couple of weeks. I am new in PowerBi therefore need support from you.

 

Regards

Uphar Tandon