Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

get an average value with filters Expand / Collapse
Author
Message
Posted Wednesday, July 17, 2013 7:37 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, April 03, 2014 12:46 PM
Points: 1,413, Visits: 4,531
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?


https://plus.google.com/100125998302068852885/posts?hl=en
http://twitter.com/alent1234
x-box live gamertag: i am null
[url=http://live.xbox.com/en-US/MyXbox/Profile[/url]
Post #1474614
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse