topic Calculate the number of customers per measure in DAX Commands and Tips

Calculate the number of customers per measure

xariet — Tue, 17 Jan 2023 02:21:51 GMT

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

Re: Calculate the number of customers per measure

Jihwan_Kim — Tue, 17 Jan 2023 03:50:13 GMT

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 ) )

Re: Calculate the number of customers per measure

xariet — Tue, 17 Jan 2023 07:41:41 GMT

Thank you Jihwan_Kim , it works perfectly!