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?