Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Filtering matrix values but not row/column totals

I have run into this problem several times where I'm trying to filter a matrice's entries, but it ends up applying the filter to the entries as well as the totals, which usually results in a pointles...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , Not very clear.

 

You can have measures like

 

if([measure] >1, [Measure], blank())

 

or

 

Sumx(Summarize(Table, Table[Row], Table[Col], "_1",if([measure] >1, [Measure], blank()) ) , [_1])

 

based on row and column columns in matrix