Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
35 | |
32 | |
18 | |
18 |