Forum Discussion
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...
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
PeerCountEven 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
PeerCountHope it helps
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 , I have been tried with All also but it doesn't remove the filter and ALLEXCEPT need minimum 2 argument.
ALLEXCEPT('pfs')
I need aggregated values in each row like this: