topic Re: Percentage of products from materials in DAX Commands and Tips

Percentage of products from materials

DimaMD — Tue, 04 Jan 2022 19:11:12 GMT

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

Re: Percentage of products from materials

Greg_Deckler — Tue, 04 Jan 2022 19:21:15 GMT

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?

Re: Percentage of products from materials

smpa01 — Tue, 04 Jan 2022 19:27:26 GMT

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

Re: Percentage of products from materials

DimaMD — Tue, 04 Jan 2022 19:39:30 GMT

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