Formula Understanding

[Melissa]

Hi @Dharma,

Please see this Forum post by @Greg and all related content in there for more details.

Dynamic Grouping

Grouping in Power BI is often referred to as segmentation, chunking, binning, banding, or bucketing. For the purposes of this article, all will be referred to as the Dynamic Grouping DAX pattern. For example, you may want to know the group totals of aged invoices in a certain time period. So, first ensure your grouping column is available in the fact table (e.g., Invoices[Aging Days]). Aging Days = SWITCH( TRUE(), Invoices[Paid in Full] = 1, 0, Invoices[Paid in Full] = 0, INT( TODAY() …

Formatting goes a long way when trying to break down DAX logic.
The outer FILTER filters Customer Names so only rows are returned that meet a condition in the inner FILTER on the supporting 'Customer Banding’ table. DAX works from the inside out, so the inner condition is evaluated before the outer filter condition.

Sales Per Growth Group =
CALCULATE(
    [Total Sales],
    FILTER(
        VALUES( Customer[Customer Names] ),
        COUNTROWS(
            FILTER(
                'Customer Banding',
                [Sales Growth_ADC] >= 'Customer Banding'[Min]
                && [Sales Growth_ADC] < 'Customer Banding'[Max]
            )
        ) > 0
    )
)

.

1. There are 2 filters because 2 different tables are being filtered
2. Countrows is a test to see if the filter condition is met, is there is a row returned from the inner Customer Banding table? If so, the customer is kept and if it doesn’t survive the filter it’s omitted.
3. Sales Growth measure is used for the test in the inner filter condition and this calculation finally returns the Total sales value of all remaining Customer Names

I hope this is helpful.