Forum Discussion
New column with count conditional for customer ID
Hi, I have a table with columns Customer_ID Store_Brand Order count Date The Store_Brand has different store brands I want to have a column that counts for each Customer_ID row the distinct ...
Hi Anonymous ,
Please try:
Distinct_Store_Brand_Count = CALCULATE(DISTINCTCOUNT('Table'[Store_Brand]),FILTER('Table',[Customer_ID]=EARLIER('Table'[Customer_ID])))Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
| Customer_ID | Store_Brand | Order count | Date | Distinct_Store_Brand_Count |
| 350-157d88f6-1b09-11 | LOBLINE | 147 | Friday, October 8, 2021 | ?? |
| 350-157d88f6-1b09-11 | KINGFISHER | 139 | Sunday, December 19, 2021 | ?? |
| 732-d39f19fd-e0f8-11 | KINGFISHER | 135 | Saturday, September 25, 2021 | ?? |
| 350-157d88f6-1b09-11 | RANDWAY | 172 | Monday, November 8, 2021 | ?? |
| 326-be30ce4a-6298-11 | LOBLINE | 55 | Friday, July 9, 2021 | ?? |
| 275-0bbd3846-d6ad-11 | RANDWAY | 39 | Friday, September 24, 2021 | ?? |
| 421-1835e540-4994-11 | NEW LION | 33 | Saturday, June 26, 2021 | ?? |
| 305-9a1dff89-70e1-11 | RANDWAY | 54 | Saturday, January 8, 2022 | ?? |
| 732-d39f19fd-e0f8-11 | RANDWAY | 96 | Friday, November 12, 2021 | ?? |
| 1155-a4fa2166-40be-1 | RANDWAY | 84 | Friday, October 1, 2021 | ?? |
| 326-be30ce4a-6298-11 | LOBLINE | 54 | Tuesday, December 21, 2021 | ?? |
| 326-be30ce4a-6298-11 | LOBLINE | 128 | Friday, September 17, 2021 | ?? |
| 350-157d88f6-1b09-11 | RANDWAY | 25 | Friday, November 19, 2021 | ?? |
| 275-0bbd3846-d6ad-11 | KINGFISHER | 143 | Tuesday, September 21, 2021 | ?? |
| 350-157d88f6-1b09-11 | LOBLINE | 121 | Saturday, November 27, 2021 | ?? |
| 596-16f269c0-60e4-11 | LOBLINE | 116 | Saturday, August 28, 2021 | ?? |
| 596-16f269c0-60e4-11 | NEW LION | 115 | Saturday, August 28, 2021 | ?? |
| 467-3e2f8285-2304-11 | KINGFISHER | 155 | Wednesday, June 23, 2021 | ?? |
| 677-9de425ff-43fe-11 | LOBLINE | 24 | Friday, October 1, 2021 | ?? |
| 305-9a1dff89-70e1-11 | LOBLINE | 79 | Friday, October 29, 2021 | ?? |
| 884-d1c80474-181a-11 | NEW LION | 54 | Saturday, June 19, 2021 | ?? |
| 136-ee45a2dc-1e5f-11 | LOBLINE | 109 | Wednesday, December 29, 2021 | ?? |
| 421-1835e540-4994-11 | RANDWAY | 151 | Thursday, October 14, 2021 | ?? |
| 467-3e2f8285-2304-11 | NEW LION | 118 | Friday, September 10, 2021 | ?? |
| 421-1835e540-4994-11 | KINGFISHER | 126 | Friday, December 3, 2021 | ?? |
| 590-7fd21221-28a0-11 | RANDWAY | 93 | Wednesday, August 18, 2021 | ?? |
| 732-d39f19fd-e0f8-11 | NEW LION | 42 | Thursday, December 23, 2021 | ?? |
| 467-3e2f8285-2304-11 | LOBLINE | 40 | Thursday, January 13, 2022 | ?? |
Hi Anonymous ,
Please try:
Distinct_Store_Brand_Count = CALCULATE(DISTINCTCOUNT('Table'[Store_Brand]),FILTER('Table',[Customer_ID]=EARLIER('Table'[Customer_ID])))Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.