Forum Discussion

rmeng's avatar
rmeng
Icon for Helper II rankHelper II
5 years ago

Calculate Growth from table

I have a table like this:

 

 

My measure are:

  • # Score = AVERAGE('Table'[Value])
  • # Score Education =
    CALCULATE (
    [# Score],
    FILTER (
    'Table',
    'Table'[Section] = "Education"
    )
    )
  • # Score Establishment =
    CALCULATE (
    [# Score],
    FILTER (
    'Table',
    'Table'[Section] = "Establishment"
    )
    )
  • Score Previous Month =
    CALCULATE (
    'SITE READINESS SECTION'[# Score],
    DATEADD ( 'DIM CALENDAR'[Date], -1, MONTH )
    )
  • Score Growth =[# Score]-[Score Previous Month]

When I add a table with measures and Archtype column the result is:

 

The result should be like this :

 

Can you help me with this?

Thanks