Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Price Development at Item Level with conditions

Dear All,    I have been sweating out for the last couple of days to calculate the price development % at item level on a certain condition.    What I'm doing is price development on a monthly ba...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

    Please create another new measure as below and put it onto the matrix visual to replace the measure [Price Change % Month-Last Year Customer _test1] , later check whether the matrix can dispaly the correct values:

    New Measure =
SUMX (
    GROUPBY (
        'Table',
        'Table'[Product Category],
        'Table'[Product Type],
        'Table'[Product Family],
        'Table'[Product Group],
        'Table'[Item],
        'Table'[Item Desc]
    ),
    [Price Change % Month-Last Year Customer _test1]
)

    Best Regards

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

Please create another new measure as below and put it onto the matrix visual to replace the measure [Price Change % Month-Last Year Customer _test1] , later check whether the matrix can dispaly the correct values:

New Measure =
SUMX (
    GROUPBY (
        'Table',
        'Table'[Product Category],
        'Table'[Product Type],
        'Table'[Product Family],
        'Table'[Product Group],
        'Table'[Item],
        'Table'[Item Desc]
    ),
    [Price Change % Month-Last Year Customer _test1]
)

Best Regards