Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Failure with calculating subcategory sum

Hi,   I am trying to calculate a value sum for a subcategory. There is a relationship on item ID from table OBSOLETE to table ITEMS.    ART_GROUP_OBS_VALUE_NEW = CALCULATE(SUM(XXBI_OBSOLETE_ITEMS...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Anonymous,

     

    Maybe you can try to use following formula calculate summary value based on current subcategory:

    ART_GROUP_VALUE_NEW =
CALCULATE (
    SUM ( XXBI_OBSOLETE_ITEMS_V[GROSS_VALUE_NEW] ),
    VALUES ( XXBI_ITEMS_MV[WEIR_OP_ARTICLE_GROUP_NAME] )
)

    If above not help, can you please share some sample data for test?

     

    Regards,

    Xiaoxin Sheng

PattemManohar's avatar
PattemManohar
Icon for Community Champion rankCommunity Champion
7 years ago
Anonymous Try to create as as measure if you want to see the total sum for each subcategory. Or if you want to store the total sum values for each subcategory then try to use SUMMARIZE function.
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi,

     

    To my opinion this is a measure. Question is why it does not work for all subcategories but only for a specific subcategory such as "frame". Most helpful would be a calculation which can calculate total value for each subcategory.

    • PattemManohar's avatar
      PattemManohar
      Icon for Community Champion rankCommunity Champion
      7 years ago
      Anonymous If it is a Measure you are looking for and all the relationships are in place, then use SUM(XXBI_OBSOLETE_ITEMS_V[GROSS_VALUE_NEW])