Forum Discussion

limonSerga's avatar
limonSerga
Regular Visitor
10 months ago
Solved

Show values on table based on columns from another table

Hello    Im having some issues generating a table, hopefully I can get some guidance on how to solve this issue. I would be greatly appreciate it.    Im trying to get the values from "Table B" to...
  • Smitho's avatar
    Smitho
    9 months ago

    This is an efficient solution and works when you can only choose 1 date.  If there is a need to select multiple dates then try:

    Parts Planned =
    CALCULATE(
    SUM('TableB'[Parts Planned]),
    TREATAS(
    VALUES('TableA'[Date]),
    'TableB'[Date]
    ),
    TREATAS(
    VALUES('TableA'[part number]),
    'TableB'[part number]
    )
    )

Hans-Georg_Puls's avatar
Hans-Georg_Puls
Icon for Super User rankSuper User
9 months ago

Hi limonSerga ,

there might be two reason for you result:

  1. Could it be that an implicit summarrization is defined for "Parts Planned". Please check if
    1. There is a sum sign in front of the your "Parts Planned" column in Data view
      1. You can deactivate that summarization by selecting the column and choose Summarization = "Don't summarize" from "Column tools" menu
    2. In Build view sum is activated as summarization for "Parts Planned"

      1. You can deactivate the summarization directly in the Data window changing the Summmarization entry
  2. You mentioned "However, this is what I get when I try to do sumx calculations". Where do you do a sumx calculation? I wouldn't expect that you need any sum or sumx calculation to get what you want.

Hope that helps.