Forum Discussion
Relating Table dataset to a Matrix to perform calculations
I need to create a relationship between two data sets that are different format to perform a calculation. Unfortunately I cannot share specifics for data privacy reasons so I will attach a pseudo-se...
HI
Create a measure say ProdCount=count(Product) with its name so for ex for Cake- 2 and so on.
Then just mulitiply it like ProdCount* No of Ingredients required say for Cake it has to be
2* 2 (Flour) and so on, looks like its simple maths.
Check with simple aggregate function Count
This measure should work as well:
zFlour = SUMX('Project', RELATED('Product'[Flour]))
Accept the solution if worked 🙂