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