Calculate function only when selected in filter

Question

HiI have a matrix with a measure that shows the total # of accounts for each sales person. The hierarchy is Director, Manager, Geography. This matrix is filterable by Geography, using the Geography table, linked by Geography. I would like to show this measure only when it is filtered to that geography. How do I change the formula? Do I add SELECTEDVALUE?&nbsp;Current Measure:&nbsp;# of Accounts = calculate(COUNTROWS((values('Salesperson Geos'[Geography]))))&nbsp;&nbsp;Data Table&nbsp;GeographyTimeProductBrandCategoryEntire CategoryVolume ShareNorthLast 4 WeeksGroup Apple&nbsp;&nbsp;Apple100NorthLast 4 WeeksProduct Red AppleOur Brand AppleApple&nbsp;80NorthLast 4 WeeksProduct Green AppleGreen AppleApple&nbsp;20NorthLast 4 WeeksGroup Grape&nbsp;&nbsp;Grape100NorthLast 4 WeeksProduct Purple GrapeOur Brand GrapeGrape&nbsp;40NorthLast 4 WeeksProduct Green GrapeGreen GrapeGrape&nbsp;60NorthLast 13 WeeksGroup Apple&nbsp;&nbsp;Apple100NorthLast 13 WeeksProduct Red AppleOur Brand AppleApple&nbsp;45NorthLast 13 WeeksProduct Green AppleGreen AppleApple&nbsp;55NorthLast 13 WeeksGroup Grape&nbsp;&nbsp;Grape100NorthLast 13 WeeksProduct Purple GrapeOur Brand GrapeGrape&nbsp;30NorthLast 13 WeeksProduct Green GrapeGreen GrapeGrape&nbsp;70SouthLast 4 WeeksGroup Apple&nbsp;&nbsp;Apple100SouthLast 4 WeeksProduct Red AppleOur Brand AppleApple&nbsp;60SouthLast 4 WeeksProduct Green AppleGreen AppleApple&nbsp;40SouthLast 4 WeeksGroup Grape&nbsp;&nbsp;Grape100SouthLast 4 WeeksProduct Purple GrapeOur Brand GrapeGrape&nbsp;35SouthLast 4 WeeksProduct Green GrapeGreen GrapeGrape&nbsp;65SouthLast 13 WeeksGroup Apple&nbsp;&nbsp;Apple100SouthLast 13 WeeksProduct Red AppleOur Brand AppleApple&nbsp;56SouthLast 13 WeeksProduct Green AppleGreen AppleApple&nbsp;44SouthLast 13 WeeksGroup Grape&nbsp;&nbsp;Grape100SouthLast 13 WeeksProduct Purple GrapeOur Brand GrapeGrape&nbsp;75SouthLast 13 WeeksProduct Green GrapeGreen GrapeGrape&nbsp;25WestLast 4 WeeksGroup Apple&nbsp;&nbsp;Apple100WestLast 4 WeeksProduct Red AppleOur Brand AppleApple&nbsp;70WestLast 4 WeeksProduct Green AppleGreen AppleApple&nbsp;30WestLast 4 WeeksGroup Grape&nbsp;&nbsp;Grape100WestLast 4 WeeksProduct Purple GrapeOur Brand GrapeGrape&nbsp;55WestLast 4 WeeksProduct Green GrapeGreen GrapeGrape&nbsp;45WestLast 13 WeeksGroup Apple&nbsp;&nbsp;Apple100WestLast 13 WeeksProduct Red AppleOur Brand AppleApple&nbsp;30WestLast 13 WeeksProduct Green AppleGreen AppleApple&nbsp;70WestLast 13 WeeksGroup Grape&nbsp;&nbsp;Grape100WestLast 13 WeeksProduct Purple GrapeOur Brand GrapeGrape&nbsp;60WestLast 13 WeeksProduct Green GrapeGreen GrapeGrape&nbsp;40EastLast 4 WeeksGroup Apple&nbsp;&nbsp;Apple100EastLast 4 WeeksProduct Red AppleOur Brand AppleApple&nbsp;65EastLast 4 WeeksProduct Green AppleGreen AppleApple&nbsp;35EastLast 4 WeeksGroup Grape&nbsp;&nbsp;Grape100EastLast 4 WeeksProduct Purple GrapeOur Brand GrapeGrape&nbsp;70EastLast 4 WeeksProduct Green GrapeGreen GrapeGrape&nbsp;30EastLast 13 WeeksGroup Apple&nbsp;&nbsp;Apple100EastLast 13 WeeksProduct Red AppleOur Brand AppleApple&nbsp;40EastLast 13 WeeksProduct Green AppleGreen AppleApple&nbsp;60EastLast 13 WeeksGroup Grape&nbsp;&nbsp;Grape100EastLast 13 WeeksProduct Purple GrapeOur Brand GrapeGrape&nbsp;64EastLast 13 WeeksProduct Green GrapeGreen GrapeGrape&nbsp;36&nbsp;Geography TableGeographyImageURLNorthexample 1Westexample 2Southexample 3Eastexample 4&nbsp;Salesperson Geos TableManagerGeographyJoeNorthJoeWestHarrySouthHarryEast

greg_deckler · Answer

MichaelaMul&nbsp;Not quite sure I am following. Perhaps create an RLS rule based to filter the data just to what each Manager should see?

michaelamul · Answer

Hi Greg,&nbsp;Sorry after reviewing my issue- I think my main problem is wanting to remove the geographies with blanks in the matrix that I have. So instead of needing to scroll to the Geography, even though it is listed for it to just show the geographies that it is filtered by.

anonymous · Answer

Hi,
Thanks fot the solution&nbsp;Greg_Deckler&nbsp; provided, and i want to offer some more information for user to refer to.
hello&nbsp;MichaelaMul&nbsp;, based on your descriotion, you can try the following measure
# of Accounts =
IF (
    ISFILTERED ( Geography[Geography] ),
    CALCULATE ( COUNTROWS ( ( VALUES ( 'Salesperson Geos'[Geography] ) ) ) ),
    BLANK ()
)

If the soution cannot meet your requirement, can you provide some sample output you want? becasue you sadi you want to display some value in matrix, which field do you put into the row and column of matrix?
&nbsp;
Best Regards!
Yolo Zhu
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.
&nbsp;

Forum Discussion

Calculate function only when selected in filter

3 Replies

Related content

Function selection

Quarter calculation upto selected month

calculate with max() function

SUM function doing wrongly calculation

calculate function

Geography	Time	Product	Brand	Category	Entire Category	Volume Share
North	Last 4 Weeks	Group Apple			Apple	100
North	Last 4 Weeks	Product Red Apple	Our Brand Apple	Apple		80
North	Last 4 Weeks	Product Green Apple	Green Apple	Apple		20
North	Last 4 Weeks	Group Grape			Grape	100
North	Last 4 Weeks	Product Purple Grape	Our Brand Grape	Grape		40
North	Last 4 Weeks	Product Green Grape	Green Grape	Grape		60
North	Last 13 Weeks	Group Apple			Apple	100
North	Last 13 Weeks	Product Red Apple	Our Brand Apple	Apple		45
North	Last 13 Weeks	Product Green Apple	Green Apple	Apple		55
North	Last 13 Weeks	Group Grape			Grape	100
North	Last 13 Weeks	Product Purple Grape	Our Brand Grape	Grape		30
North	Last 13 Weeks	Product Green Grape	Green Grape	Grape		70
South	Last 4 Weeks	Group Apple			Apple	100
South	Last 4 Weeks	Product Red Apple	Our Brand Apple	Apple		60
South	Last 4 Weeks	Product Green Apple	Green Apple	Apple		40
South	Last 4 Weeks	Group Grape			Grape	100
South	Last 4 Weeks	Product Purple Grape	Our Brand Grape	Grape		35
South	Last 4 Weeks	Product Green Grape	Green Grape	Grape		65
South	Last 13 Weeks	Group Apple			Apple	100
South	Last 13 Weeks	Product Red Apple	Our Brand Apple	Apple		56
South	Last 13 Weeks	Product Green Apple	Green Apple	Apple		44
South	Last 13 Weeks	Group Grape			Grape	100
South	Last 13 Weeks	Product Purple Grape	Our Brand Grape	Grape		75
South	Last 13 Weeks	Product Green Grape	Green Grape	Grape		25
West	Last 4 Weeks	Group Apple			Apple	100
West	Last 4 Weeks	Product Red Apple	Our Brand Apple	Apple		70
West	Last 4 Weeks	Product Green Apple	Green Apple	Apple		30
West	Last 4 Weeks	Group Grape			Grape	100
West	Last 4 Weeks	Product Purple Grape	Our Brand Grape	Grape		55
West	Last 4 Weeks	Product Green Grape	Green Grape	Grape		45
West	Last 13 Weeks	Group Apple			Apple	100
West	Last 13 Weeks	Product Red Apple	Our Brand Apple	Apple		30
West	Last 13 Weeks	Product Green Apple	Green Apple	Apple		70
West	Last 13 Weeks	Group Grape			Grape	100
West	Last 13 Weeks	Product Purple Grape	Our Brand Grape	Grape		60
West	Last 13 Weeks	Product Green Grape	Green Grape	Grape		40
East	Last 4 Weeks	Group Apple			Apple	100
East	Last 4 Weeks	Product Red Apple	Our Brand Apple	Apple		65
East	Last 4 Weeks	Product Green Apple	Green Apple	Apple		35
East	Last 4 Weeks	Group Grape			Grape	100
East	Last 4 Weeks	Product Purple Grape	Our Brand Grape	Grape		70
East	Last 4 Weeks	Product Green Grape	Green Grape	Grape		30
East	Last 13 Weeks	Group Apple			Apple	100
East	Last 13 Weeks	Product Red Apple	Our Brand Apple	Apple		40
East	Last 13 Weeks	Product Green Apple	Green Apple	Apple		60
East	Last 13 Weeks	Group Grape			Grape	100
East	Last 13 Weeks	Product Purple Grape	Our Brand Grape	Grape		64
East	Last 13 Weeks	Product Green Grape	Green Grape	Grape		36

Geography	ImageURL
North	example 1
West	example 2
South	example 3
East	example 4