Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Help with Matrix Total

Hello Community. I would like assistance with the following. I have the following tables and a measure. As you can see the measure if throwing the proper results per row, but the total is not coming up. I need assistance on what to enter in the ??? section of my code. Thanks. 

Measure

 

Tables - Matrix

 

 

  • Anonymous's avatar
    Anonymous
    7 years ago
    [Total Sales Amount] = sum ( Sales[Amount] ) -- base measure
[Total Target Amount] = sum ( Geo[Target] ) -- base measure

[Adjusted Amount for Single Geo] = -- this measure should be hidden
var __oneGeoVisible = hasonevalue ( Geo[Geo] )
var __ACsum=
	calculate (
		[Total Sales Amount],
		keepfilters (
			treatas (
				{"A", "C"},
				Sales[Category]
			)
		)
	)
var __targetSum = [Total Target Amount]
var __adjustedAmount = max ( __ACsum, __targetSum )
return
	if ( __oneGeoVisible, __adjustedAmount )
	
[Adjusted Amount] = -- this is what you wanted
sumx(
	values ( Geo[Geo] ),
	[Adjusted Amount for Single Geo]
)

    Best

    Darek

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago
    [Total Sales Amount] = sum ( Sales[Amount] ) -- base measure
[Total Target Amount] = sum ( Geo[Target] ) -- base measure

[Adjusted Amount for Single Geo] = -- this measure should be hidden
var __oneGeoVisible = hasonevalue ( Geo[Geo] )
var __ACsum=
	calculate (
		[Total Sales Amount],
		keepfilters (
			treatas (
				{"A", "C"},
				Sales[Category]
			)
		)
	)
var __targetSum = [Total Target Amount]
var __adjustedAmount = max ( __ACsum, __targetSum )
return
	if ( __oneGeoVisible, __adjustedAmount )
	
[Adjusted Amount] = -- this is what you wanted
sumx(
	values ( Geo[Geo] ),
	[Adjusted Amount for Single Geo]
)

    Best

    Darek