Forum Discussion

VendettaBob's avatar
VendettaBob
Helper II
3 years ago

Remove filter with ALL

Hi,

 

I'm am having a little trouble trouble with filtering values.

 

My code is currently as follows:

 

 

On the PowerBI page I want the calculation to exclude the fields: 

ALL (CustomerSiteAddress[CompanyGroupCustomerNumber],CustomerSiteAddress[Customer Site Name],CustomerSiteAddress[LocationAddress3])

 

I'm sure this is straightforward just having a little issue with the syntax.

 

Thanks,

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi VendettaBob ,

    Please modify your formula.

    _maxlastcompletedate=var revisedvalues=maxx(summarize('serviceorderheadercustomer','Individualitem'[IndividualitemI],"Lastfinshdate",calculate(max('serviceorderassignment'[Assignmentfinsheddate]),filter(all('serviceorderassignment'),Year('serviceorderassignment'[Assignmentfinsheddate])<>2079))),[lastfinisheddate])
return
if(hasonevalue('Individualitem'[IndividualitemI]),revisedvalues,blank()

    If I have misundrestood your meaning, please provide more details with your desired output and pbix file without privacy information.

     

     Best Regards

    Community Support Team _ Polly

     

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

    • VendettaBob's avatar
      VendettaBob
      Helper II
      3 years ago

      Hi Polly,

       

      That's not going to work. 

       

      I need to exclude the customersiteaddress dimension: CustomerSiteAddress[CompanyGroupCustomerNumber

       

      Your query excludes everything from a the serviceorderassignment dimension.

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi VendettaBob ,

        How to Get Your Question Answered Quickly 

         

         Please provide more details with your desired output and pbix file without privacy information.

         

         Best Regards

        Community Support Team _ Polly

         

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