get an average value with filters

• alen teplitsky

  SSC-Dedicated

  Points: 30014

  More actions

  July 17, 2013 at 7:37 am

  #151260

  i'm learning 2012 analysis services. i set up a test server with the tabular model.

  for my first project i have a combined backupset from the msdb database from different servers with our entire backup history going back many years

  i'm trying to create a measure to get an average value of the backup_size column but with filters depending on the server name and maybe the database name

  i tried this and it didn't work. =average('dimbackupdata'[backup_size]), ('dimbackupdata'[server_name]="server-name"))

  is this possible in tabular? or should i go and try to do this in Multidimensional?