ALL not ignoring column filter

[vpatel55]

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 to be working. If I add ALL on the whole table, then it does work. However, this would not be acceptable as that would also ignore my row filters, which I do not want.

Any ideas as to how I can ignore just the column name? I don't have any age page level or visual level filters. Thanks.

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

[v-xiaotang]

Hi @vpatel55 

Thanks for reaching out to us.

When I test, the all() function works ok, could you please share a sample file for us to check? Thanks

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[vpatel55 · Accepted solution]

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.

[vpatel55]

Thanks @Anonymous but same result i'm afraid, the column continues to filter.

[Anonymous]

Vpatel55,

Try to removefilters on postalcode, this is the last filter on your display ?

[vpatel55]

Thanks @Anonymous but same issue, in fact even if I remove PostcodeArea from the row axis, leaving just the column, it still filters by column (screenshot below). I'm not aware of any other filters at all. Its an odd one!

[Anonymous]

vpatel55,

last chance 🙂 

your 0,1,2... what is this field ? 

[vpatel55]

No problem @Anonymous , its a table of grouped numbers. The data type is decimal, but changing it to whole number doesn't change the result. My ultimate goal is produce a cumulative percentage. So that '1' is x% of the total, 2 is y% of the total, etc.

[Anonymous]

i,

Tyr this

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