Forum Discussion

vpatel55's avatar
vpatel55
Icon for Kudo Commander rankKudo Commander
4 years ago
Solved

ALL not ignoring column filter

Using the following code, I'm trying to get ALL to ignore a column filter. It should mean that all the colum values should be exactly the same. However, the values are different and ALL does not seem...
Need Help
  • vpatel55's avatar
    vpatel55
    4 years ago

    Hi, i'm afraid that the file is very big and contains sensitive data. In the end, I pasted into Excel and worked out manually. It could be a bug, as the code is otherwise what it should be. This will probably not have a solution, so feel free to delete the thread. Thanks.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

i,

 

Tyr this

MeasureName =
CALCULATE (
    COUNTA ( tblJobs[ColumnName] ),
    ALL ( tblJobs[ColumnName] ),removefilters(tblJobs[ColumnName] )
)