Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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?
Solved! Go to 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 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
@smpa01 Hi,
Thank you for helping to understand how to calculate, I am very grateful to you.
The measures worked
@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?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
23 | |
17 | |
11 | |
11 | |
10 |
User | Count |
---|---|
32 | |
25 | |
15 | |
13 | |
13 |