Calculate the number of customers per measure

[xariet]

Hi All!

I need help with calculating the number of customers based on the same number of Customer Lifetime Months. Basically, I need to create a bar chart that will show how many customers we have who stayed with us for 47, 46, etc months. Customer Lifetime Months is the measure I've created. Any help is appreciated

[Jihwan_Kim · Accepted solution]

Hi,

I tried to create a sample pbix file like below.

One of ways to achieve this is to create an axis table something like below.

Please check the below picture and the attached pbix file.

Customers count by Lifetime measure: =
VAR _axis =
    MAX ( 'Axis table'[Lifetime Measure result] )
RETURN
    COUNTROWS (
        FILTER (
            ADDCOLUMNS (
                DISTINCT ( Data[Customer] ),
                "@lifetimemeasure", [Lifetime measure:]
            ),
            [@lifetimemeasure] = _axis
        )
    )

[xariet]

Thank you @Jihwan_Kim , it works perfectly!