Forum Discussion
Solved
Count if Measure = certain value
Hi everyone, I am trying to make a measure to count the number of NEW Distributions there was in the latest week. I have the following measure that indicates if it is NEW. Now I am trying to count t...
Hi , Thank you for reaching out to the Microsoft Community Forum.
I have reproduced your scenario in Power BI Desktop and successfully implemented a solution where we added a column to check if a product had sales this week but not the week before, marking it as a new distribution. Then we created a measure to count how many of these new distributions happened in the latest week. It returns 0 when there are none, and a number when new ones appear.
For your reference, I’ve attached the working .pbix file.
If this helped solve the issue, please consider marking it “Accept as Solution” so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.
Sample Data:
| New Distribution | Geography | Time | Product | Volume Sales | Volume Sales Year Ago | Volume Sales % Change vs PP | Date | LatestWeek? |
| A Store | Week Ending 06-29-25 | Creamer | 37.5 | 476.92% | 6/29/2025 | TRUE | ||
| NEW | A Store | Week Ending 06-22-25 | Creamer | 6.5 | 6/22/2025 | FALSE | ||
| A Store | Week Ending 06-15-25 | Creamer | 6/15/2025 | FALSE | ||||
| A Store | Week Ending 06-08-25 | Creamer | 6/8/2025 | FALSE | ||||
| A Store | Week Ending 06-01-25 | Creamer | 6/1/2025 | FALSE | ||||
| A Store | Week Ending 05-25-25 | Creamer | 5/25/2025 | FALSE | ||||
| A Store | Week Ending 05-18-25 | Creamer | 5/18/2025 | FALSE | ||||
| A Store | Week Ending 05-11-25 | Creamer | 5/11/2025 | FALSE | ||||
| A Store | Week Ending 05-04-25 | Creamer | 5/4/2025 | FALSE | ||||
| A Store | Week Ending 04-27-25 | Creamer | 4/27/2025 | FALSE | ||||
| A Store | Week Ending 04-20-25 | Creamer | 4/20/2025 | FALSE | ||||
| A Store | Week Ending 04-13-25 | Creamer | 4/13/2025 | FALSE | ||||
| A Store | Week Ending 04-06-25 | Creamer | 4/6/2025 | FALSE | ||||
| A Store | Week Ending 03-30-25 | Creamer | 3/30/2025 | FALSE | ||||
| A Store | Week Ending 03-23-25 | Creamer | 3/23/2025 | FALSE | ||||
| A Store | Week Ending 03-16-25 | Creamer | 3/16/2025 | FALSE | ||||
| A Store | Week Ending 03-09-25 | Creamer | 3/9/2025 | FALSE | ||||
| A Store | Week Ending 03-02-25 | Creamer | 3/2/2025 | FALSE | ||||
| A Store | Week Ending 02-23-25 | Creamer | 2/23/2025 | FALSE | ||||
| A Store | Week Ending 02-16-25 | Creamer | 2/16/2025 | FALSE | ||||
| A Store | Week Ending 02-09-25 | Creamer | 2/9/2025 | FALSE | ||||
| A Store | Week Ending 02-02-25 | Creamer | 2/2/2025 | FALSE | ||||
| A Store | Week Ending 01-26-25 | Creamer | 1/26/2025 | FALSE | ||||
| A Store | Week Ending 01-19-25 | Creamer | 1/19/2025 | FALSE | ||||
| A Store | Week Ending 01-12-25 | Creamer | 1/12/2025 | FALSE | ||||
| A Store | Week Ending 01-05-25 | Creamer | 1/5/2025 | FALSE | ||||
| A Store | Week Ending 12-29-24 | Creamer | 12/29/2024 | FALSE | ||||
| A Store | Week Ending 12-22-24 | Creamer | 12/22/2024 | FALSE | ||||
| A Store | Week Ending 12-15-24 | Creamer | 12/15/2024 | FALSE | ||||
| A Store | Week Ending 12-08-24 | Creamer | 12/8/2024 | FALSE | ||||
| A Store | Week Ending 12-01-24 | Creamer | 12/1/2024 | FALSE | ||||
| A Store | Week Ending 11-24-24 | Creamer | 11/24/2024 | FALSE | ||||
| A Store | Week Ending 11-17-24 | Creamer | 11/17/2024 | FALSE | ||||
| A Store | Week Ending 11-10-24 | Creamer | 11/10/2024 | FALSE | ||||
| A Store | Week Ending 11-03-24 | Creamer | 11/3/2024 | FALSE | ||||
| B Store | Week Ending 06-29-25 | Creamer | 129.5 | -7.66% | 6/29/2025 | TRUE | ||
| B Store | Week Ending 06-22-25 | Creamer | 140.25 | -30.31% | 6/22/2025 | FALSE | ||
| B Store | Week Ending 06-15-25 | Creamer | 201.25 | -26.75% | 6/15/2025 | FALSE | ||
| B Store | Week Ending 06-08-25 | Creamer | 274.75 | 81.95% | 6/8/2025 | FALSE | ||
| B Store | Week Ending 06-01-25 | Creamer | 151 | 6/1/2025 | FALSE | |||
| B Store | Week Ending 05-25-25 | Creamer | 151 | 3.42% | 5/25/2025 | FALSE | ||
| B Store | Week Ending 05-18-25 | Creamer | 146 | 0.52% | 5/18/2025 | FALSE | ||
| B Store | Week Ending 05-11-25 | Creamer | 145.25 | 12.16% | 5/11/2025 | FALSE | ||
| B Store | Week Ending 05-04-25 | Creamer | 129.5 | -42.44% | 5/4/2025 | FALSE | ||
| B Store | Week Ending 04-27-25 | Creamer | 225 | 63.93% | 4/27/2025 | FALSE | ||
| B Store | Week Ending 04-20-25 | Creamer | 137.25 | -10.44% | 4/20/2025 | FALSE | ||
| B Store | Week Ending 04-13-25 | Creamer | 153.25 | -2.23% | 4/13/2025 | FALSE | ||
| B Store | Week Ending 04-06-25 | Creamer | 156.75 | -1.26% | 4/6/2025 | FALSE | ||
| B Store | Week Ending 03-30-25 | Creamer | 158.75 | -36.69% | 3/30/2025 | FALSE | ||
| B Store | Week Ending 03-23-25 | Creamer | 250.75 | 71.45% | 3/23/2025 | FALSE | ||
| B Store | Week Ending 03-16-25 | Creamer | 146.25 | -3.15% | 3/16/2025 | FALSE | ||
| B Store | Week Ending 03-09-25 | Creamer | 151 | 0.50% | 3/9/2025 | FALSE | ||
| B Store | Week Ending 03-02-25 | Creamer | 150.25 | -2.75% | 3/2/2025 | FALSE | ||
| B Store | Week Ending 02-23-25 | Creamer | 154.5 | -4.33% | 2/23/2025 | FALSE | ||
| B Store | Week Ending 02-16-25 | Creamer | 161.5 | -1.97% | 2/16/2025 | FALSE | ||
| B Store | Week Ending 02-09-25 | Creamer | 164.75 | 5.44% | 2/9/2025 | FALSE | ||
| B Store | Week Ending 02-02-25 | Creamer | 156.25 | -22.55% | 2/2/2025 | FALSE | ||
| B Store | Week Ending 01-26-25 | Creamer | 201.75 | 144.55% | 1/26/2025 | FALSE | ||
| B Store | Week Ending 01-19-25 | Creamer | 82.5 | -42.61% | 1/19/2025 | FALSE | ||
| B Store | Week Ending 01-12-25 | Creamer | 143.75 | 88.52% | 1/12/2025 | FALSE | ||
| NEW | B Store | Week Ending 01-05-25 | Creamer | 76.25 | 1/5/2025 | FALSE | ||
| B Store | Week Ending 12-29-24 | Creamer | 12/29/2024 | FALSE | ||||
| B Store | Week Ending 12-22-24 | Creamer | 12/22/2024 | FALSE | ||||
| B Store | Week Ending 12-15-24 | Creamer | 12/15/2024 | FALSE | ||||
| B Store | Week Ending 12-08-24 | Creamer | 12/8/2024 | FALSE | ||||
| B Store | Week Ending 12-01-24 | Creamer | 12/1/2024 | FALSE | ||||
| B Store | Week Ending 11-24-24 | Creamer | 11/24/2024 | FALSE | ||||
| B Store | Week Ending 11-17-24 | Creamer | 11/17/2024 | FALSE | ||||
| B Store | Week Ending 11-10-24 | Creamer | 11/10/2024 | FALSE | ||||
| B Store | Week Ending 11-03-24 | Creamer | 11/3/2024 | FALSE |
Hi,
Based on the table that you have selected, what answer are you expecting? Also, which of those columns are raw data columns? Are you looking for an all measures solution? What is the definition of a New Distributor?