Count the number of price changes

[preethisaldanha]

I have created a measure to caluclate the difference in price this month vs last month and now I want to count all the number of products that have had the price change, please can you advise how this can be done.

Price change = Calculate(IF([Previous Month]=0, 0,[Current Month]-[Previous Month]),'All detail'[Month] =  MAX('All detail'[Month]))

article	Aug	July
x	10	5
y	5	3
z	15	15
a	12	12
a	10	7
c	20	8

[123abc · Accepted solution]

To count the number of products that have had a price change, you can create a new measure that evaluates whether the "Price change" measure is not equal to 0 for each product. You can use the COUNTROWS function to count the rows where this condition is met. Here's how you can do it:

DAX Formula:

Price Change Count =
COUNTROWS(
FILTER(
SUMMARIZE('All detail', 'All detail'[article]),
[Price change] <> 0
)
)

This measure will count the number of products (articles) that have had a price change during the specified period. It uses the FILTER function to create a filtered table where the "Price change" measure is not equal to 0, and then COUNTROWS counts the rows in that filtered table.

Now, when you use the "Price Change Count" measure in your visualizations or tables, it will display the count of products with price changes for the given month.

[preethisaldanha]

Thank you much appreciated. The solution worked.

[123abc]

You welcome.