Forum Discussion

naal1995's avatar
naal1995
New Member
8 years ago

Filter to exclude values in which the excludes rows for which the amout of times the text mentioned

 

 

I tried to recreate the problem in excel for simplfaction and to protect data.

 

I need to create a filter in which in this example Supplier C gets excluded from the graph because the number of SKU they delivered is under 2.

 

The number of SKU should be calicated from my base table which has every item delivered and per item it says which supplier it comes from. I then need a way to summairze that data so that if lets say in this 7 items supplier B has delivered 7 4 items it creates a colum with the number 4 and then I can use that colum in a summery table that I've created which only has the suppliers and the rank of the performance based on percentage.

 

Anyone know how to do this is power BI ?

 

1 Reply

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    8 years ago

    Hi naal1995,

     

    You could calculate the Amout of SKU with the formula below.

     

    Measure =
CALCULATE (
    COUNT ( 'Base Table'[Supplier] ),
    FILTER (
        ALL ( 'Base Table' ),
        'Base Table'[Supplier] = MAX ( 'Base Table'[Supplier] )
    )
)

     

     

    I 'm a little confused about your Percent, but you could calculate the Rank column with Rankx function in Power BI.

     

    Then you could create the Clusetered column chart with the Supplier as Axis and Rank column as value.

     

    Best Regards,

    Cherry