Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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

  • grantsamborn's avatar
    grantsamborn
    4 years ago

    This measure should work as well:

    zFlour = SUMX('Project', RELATED('Product'[Flour]))
Anonymous's avatar
Anonymous
Not applicable
4 years ago

I would suggest you to calculate count of Orders and then multiply it with Ingradients

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Yes, exactly.  What is the syntax for a measure that will do that? 

    I can use Countrows(Table[Product]) to get a count for each of the orders per product.

    But I do not know how to multiply by the product name in the matrix

     

    In excel I can xlookup by the product name then cross check and return the product of the two.  I dont know if DAX has a similar function.