Matrix with Top 10 but Total all

[Pikachu-Power]

Hi all,

I have a matrix filtered with top 10. but as a total I want the whole number not filtered with top 10. is it possible to handle it in one matrix?

thanks. 

[amitchandak]

use isfiltered or hasonevalue and change the formula https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

Or instead of filter use if like (Not tested for measure like rank)

Sumx(Table,if([Rank]<=10,[Measure],0)

[Pikachu-Power]

I am not sure if we talk about the same values. I have a matrix like this:

Filtered with Top 3 for example. Instead of 6 I want the whole sum. For example 10 for existing A,B,C,X,Y.

[az38 · Accepted solution]

Hi @Pikachu-Power 

Let's assume we have a table

Column1	Column2	Value
A	d	1
B	d	1
C	d	3
X	d	2
Y	d	2
B	d	2
A	e	4
B	e	5
C	e	6
X	e	7
Y	e	8

That table could be presented as your Matrix

To achieve your goal create a measure

Measure = IF(
HASONEVALUE('Table'[Column1]),
CALCULATE(SUM('Table'[Value])),
CALCULATE(SUM('Table'[Value]),ALL('Table'[Column1]))
)

and place it as Value into your matrix as follow:

[Greg_Deckler]

Yes, use HASONEVALUE or ISINSCOPE and then you can identify the total row and in that case, SUMX(ALL('Table'),[Column])