Fix DSO Branch/Customer Filter
Budget: $15 – $25 USD
My power bi includes a Days Sales Outstanding (DSO) filter that should narrow results by both branch and customer. Right now the filter returns incorrect figures, so decision-making reports are unreliable.
Here is what I need:
• Analyse the existing filter logic.
• Identify why selections for branch, customer, or their combination are pulling the wrong dataset.
• Update the dax so the returned DSO values exactly match the underlying source data.
Acceptance criteria
– Selecting a single branch shows accurate DSO for that branch only.
– Selecting a single customer shows accurate DSO for that customer only.
– Combining both filters shows the intersected, correct dataset.
– No performance degradation (response time remains within existing norms).
Here is what I need:
• Analyse the existing filter logic.
• Identify why selections for branch, customer, or their combination are pulling the wrong dataset.
• Update the dax so the returned DSO values exactly match the underlying source data.
Acceptance criteria
– Selecting a single branch shows accurate DSO for that branch only.
– Selecting a single customer shows accurate DSO for that customer only.
– Combining both filters shows the intersected, correct dataset.
– No performance degradation (response time remains within existing norms).