topic Re: Count of rows with condition and grouping by Customer ID to return one figure in DAX Commands and Tips

Count of rows with condition and grouping by Customer ID to return one figure

Vsthesound — Tue, 04 Oct 2022 02:32:57 GMT

Hey guys, I really need help with this dataset,its giving me serious headaches. I want to Count the number of times each 'Account Number' subscribed within 6 months.

I am having serious issue GROUPING each 'AccountNumber' to return one figure (i.e No of times/Count of Data subscribed within 6 months). Please see dataset preview below and kindly assist. Thank you.

Your swift response is highly appreciated.

Re: Count of rows with condition and grouping by Customer ID to return one figure

tamerj1 — Tue, 04 Oct 2022 03:17:42 GMT

Hi Vsthesound

would you please provide the expected results based on the the same sample data?

Re: Count of rows with condition and grouping by Customer ID to return one figure

Vsthesound — Tue, 04 Oct 2022 03:28:35 GMT

Expected result should be

Account Number Count/No of Times Subscribed in 6 months

1000001 6

1000002 6

Re: Count of rows with condition and grouping by Customer ID to return one figure

tamerj1 — Tue, 04 Oct 2022 04:23:18 GMT

Vsthesound

what if the data for an account contains more than 6 months? A year for example? Which 6 months shall be considered? I'm asking this because as per your example, COUNTROWS ( 'Table' ) shall do the job but I don't think you actual requirement is just as simple as that, is it?

Re: Count of rows with condition and grouping by Customer ID to return one figure

Vsthesound — Tue, 04 Oct 2022 12:16:58 GMT

Thank you so much. The data for each account is strictly for 6 months only. If you refer to the image on very my first post, you will see that the dates for each account ranges from July-December 2019.

Re: Count of rows with condition and grouping by Customer ID to return one figure

tamerj1 — Tue, 04 Oct 2022 13:06:45 GMT

Hi Vsthesound
Then just use
COUNT = COUNTROWS ( 'Table' )

Re: Count of rows with condition and grouping by Customer ID to return one figure

Vsthesound — Tue, 04 Oct 2022 13:24:00 GMT

This formula just counts all the rows on the table. I need a formula that counts the rows and group them by account number , for every time the account subscribed within 6 months.

The maximum number of expected Count for an account that subscribed 6times out of 6 months = 6

Count for an account that subscribed 5times out of 6 months = 5

Count for an account that subscribed 4times out of 6 months = 4

etc.

I hope this explains it better.

Re: Count of rows with condition and grouping by Customer ID to return one figure

tamerj1 — Tue, 04 Oct 2022 13:35:34 GMT

Vsthesound
If you create it as a measure it should give you the expected result. Please try and share a screenshot of the results

Re: Count of rows with condition and grouping by Customer ID to return one figure

Vsthesound — Tue, 04 Oct 2022 16:53:49 GMT

It worked!. Thank you so much😁.