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 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] )
)

 

 

 

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.

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    i,

     

    Tyr this

    MeasureName =
CALCULATE (
    COUNTA ( tblJobs[ColumnName] ),
    ALL ( tblJobs[ColumnName] ),removefilters(tblJobs[ColumnName] )
)
  • vpatel55's avatar
    vpatel55
    Icon for Kudo Commander rankKudo Commander
    4 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Vpatel55,

       

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

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

        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!

         

         

  • v-xiaotang's avatar
    v-xiaotang
    Icon for Community Support rankCommunity Support
    4 years ago

    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's avatar
      vpatel55
      Icon for Kudo Commander rankKudo Commander
      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.