Percentage of products from materials

[DimaMD]

Hello community.

I need to make some interesting calculations

We have a table which consists of ready products and materials.

The goal is to calculate percentage of ready products that contains in materials. For that reason we need to calculate total ammount of materials. Then we need to divide every amount of ready product with total ammount of materials so we could get percentage that has this ready product in materials.

With what mesure can I achive that?

 Example pbix

[smpa01 · Accepted solution]

@DimaMD  change to following

Material = CALCULATE( SUM('Table'[Amount]), 'Table'[View]="Material",REMOVEFILTERS('Table'[Product],'Table'[Amount]))

RedyProdyct = CALCULATE( SUM('Table'[Amount]),'Table'[View] = "RedyProduct" )

% material = DIVIDE(
    [RedyProdyct],[Material])

gives you this

[DimaMD]

@smpa01 Hi,
Thank you for helping to understand how to calculate, I am very grateful to you.
The measures worked

[Greg_Deckler]

@DimaMD In looking at the PBIX file, I am not sure how to identify which ready products have which materials in them. Or is that not important?