How to omit totals for specified rows in matrix

[Anonymous]

I've created a matrix based off sql server data where it pivots the columns (months). These are dynamic and will grow each month (e.g a new column added to the right of the matrix with the month name and the data in rows under it). I'm using the subtotal function to tally up the month's data across all months for each row, however, there are metrics such as rates, percentages, and averages that I do NOT want to be totaled for obvious reasons. Is there a way to get a measure or calculated column to display (and move to the right) as the data matrix "grows" each month or can the subtotal option be customized so that it excludes certain values based on a name?

I'd like it total as it is, but have blank values in the "Total" Column for measures such as "Fill Rate %".

The column that displays the data for this visual is a measure I created that divides the totals by # of specific rows (providers in this case). I basically want to omit the totaling for these same metrics:

Units = 
 SUMX(MMP_Dashboards_WMH_PBI, IF (MMP_Dashboards_WMH_PBI[Revenue_Center]IN {"FillRate","CancelRt","NoShowRt","ExamRt","Officelag","Hospitallag","Npapptlag"},
DIVIDE ( 
Calculate(
SUM ( MMP_Dashboards_WMH_PBI[NewUnits] ), MMP_Dashboards_WMH_PBI[Revenue_Center] IN {"FillRate","CancelRt","NoShowRt","ExamRt","Officelag","Hospitallag","npapptlag"}
),

COUNTROWS ( VALUES ( MMP_Dashboards_WMH_PBI[Provider_Finance] )) 
),MMP_Dashboards_WMH_PBI[NewUnits]
))

Any help is greatly appreciated!

[AlexisOlson · Accepted solution]

The ISINSCOPE function is good for controlling the results returned at different levels of granularity.

For example, this will return a blank value unless the value in a matrix visual has DimDate[Date] on the rows or columns. (The total column in your particular example does not have any date in scope.)

IF ( ISINSCOPE ( DimDate[Date] ), [Measure1] )