Filtering while using this formula “ Count(distinct Borrower_Group_Name)- Count({<Onboarding_Status = {'J) Sold During The Process'}>} distinct Borrower_Group_Name) ” creates weird results (negative values, graphs not shown, etc).
this is mainly because the second part of the formula is greater than the first one when filter applies.
is there another formula, technique I can apply here? Given that I want to remove the sold assets from all the kPIs and charts