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 (Custo...
Need Help
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.