Calculated Measure Not Working With Filter

[krodocker]

I am trying to calculate the percentage of "Spend" received for each "Item" per "Supplier" using the measure below. (For example, Item A has 60% Spend with Supplier1 and 40% Spend with Supplier2.) This measure calculates correctly until I apply a filter for Item... then all percentages show as 100%. How can I maintain the percentage when applying the filter?

Percentage of Spend Received by Supplier Per Item =

DIVIDE(
CALCULATE(SUM(TABLE1[Spend]),

FILTER(TABLE1,TABLE1[Supplier] = TABLE1[Supplier])),

CALCULATE(SUM(TABLE1[Spend]),
ALLSELECTED(TABLE1), TABLE1[Item] IN VALUES(TABLE1[Item])))

[az38]

Hi @krodocker 

TABLE1[Supplier] = TABLE1[Supplier]

it is a very strange condition for any filter, doesn't it? it will return you all the table 

[Pragati11]

Hi @krodocker ,

Try modifying yourcalculation to:

DIVIDE(
           CALCULATE(SUM(TABLE1[Spend]), FILTER(ALLSELECTED(TABLE1),TABLE1[Supplier] = TABLE1[Supplier])),

           CALCULATE(SUM(TABLE1[Spend]), ALLSELECTED(TABLE1), TABLE1[Item] IN VALUES(TABLE1[Item]))

           )

Let me know if this works.

Thanks.

[Stachu]

Can you add sample tables (in format that can be copied to PowerBI) from your model with anonymised data? Like this (just copy and paste into the post window).

Column1	Column2
A	1
B	2.5