Forum Discussion

krodocker's avatar
krodocker
Regular Visitor
6 years ago

Calculated Measure Not Working With Filter

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.) Th...
Pragati11's avatar
Pragati11
Super User
6 years ago

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.