Forum Discussion
Count if Measure = certain value
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.
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.
Thank you!! This worked!