Filtering issue

[setis]

Dear all, 

I hope that you can help me with this. Apologies for not preparing an example file. 

The relevant part of my data model is this: 

What I'm trying to do is creating a measure calculating the % of activities per customer filtering a "FeeType" out.

I've tried:

NrofActivities = COUNT(Activities[CaseID])

ActivitiesNo_TypeA = CALCULATE([NrofActivities];
FILTER(ALL(Fees); NOT(
Fees[FeeType]="TypeA")))

Activities%GT_No_TypeA = DIVIDE (
                 [ActivitiesNo_TypeA];
                 CALCULATE([ActivitiesNo_TypeA];ALLSELECTED(Customers)))

 The measure seems to be working on a table with the activity types:

However it is not working when matched with customers:

Thank you very much in advance 🙂

[setis]

Dear experts, 

I can imagine that it's difficult to help without a sample file. I have prepared an example here reproducing my issue.

I hope that somebody can help me with this 🙂

https://drive.google.com/file/d/1TIjSGnNCKhickmUQWBrjd2wX9dp3uME3/view?usp=sharing

My issue as you can see in there is to filter the Nr of activities that are not TypeA, by customer. 

[parry2k · Accepted solution]

@setis  I'm not sure why you have ALL(FEES) , it should be only FEES . Can you update the measure and test it?

[setis]

Dear @parry2k thanks a lot! There was my mistake. 

[parry2k]

@setis no worries, I'm glad it worked out without going further debugging. Cheers!!!