Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

remove filter in row context

Hi, I am using a measure on Card and table visuals. The measure is giving correct value when using it on the card visual but due to row context, it divide the values when placing this measure on tab...
Need Help
  • AilleryO's avatar
    AilleryO
    4 years ago

    Hi,

     

    Not 100% sure of what you expect but if I get it right using ALL instead of ALLEXCEPT should do the trick :

    Count =
    var CNo = SELECTEDVALUE('cfs'[CNumber],BLANK())
    var PCount = CALCULATE( DISTINCTCOUNT ('pfs'[CNumber]) , 'pfs'[CNumber] <> CNo, ALL('pfs',[Stage]))
    Return
               PeerCount
     
    Even if you want to get rid of all filters on table pfs :
     
    Count =
    var CNo = SELECTEDVALUE('cfs'[CNumber],BLANK())
    var PCount = CALCULATE( DISTINCTCOUNT ('pfs'[CNumber]) , 'pfs'[CNumber] <> CNo, ALLEXCEPT('pfs'))
    Return
               PeerCount
     
    Hope it helps
     
AilleryO's avatar
AilleryO
Memorable Member
4 years ago

Hi,

 

Sorry my bad, should be :

Count =
var CNo = SELECTEDVALUE('cfs'[CNumber],BLANK())
var PCount = CALCULATE( DISTINCTCOUNT ('pfs'[CNumber]) , 'pfs'[CNumber] <> CNo, ALL('pfs',[CNumber]))
Return
      PeerCount

 Assuming CNumber is the peer number you need to remove to aggregate.

Or :

Count =
var CNo = SELECTEDVALUE('cfs'[CNumber],BLANK())
var PCount = CALCULATE( DISTINCTCOUNT ('pfs'[CNumber]) , 'pfs'[CNumber] <> CNo, ALLEXCEPT('pfs',[Stage]))
Return
      PeerCount

 

Could be another solution, to keep filters on Stage (assuming stage is the column with High, Low, Verbal).

Hope it helps