Forum Discussion
CANTIDAD DE LOCALES
Hi YOSIEMPREYO12 ,
You can make use of SUMX function here which will count stores that sold the article, and then sums it properly across months.Assuming you have a date table and your model is correctly related.
StoresSoldPerMonth =
SUMX(
VALUES('Date'[Month]),
CALCULATE(
DISTINCTCOUNT(Sales[Store]),
Sales[TotalSale] > 0
)
)
Hope this helps!
If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.
Community SupportHi YOSIEMPREYO12 ,
You can make use of SUMX function here which will count stores that sold the article, and then sums it properly across months.
Assuming you have a date table and your model is correctly related.
StoresSoldPerMonth =
SUMX(
VALUES('Date'[Month]),
CALCULATE(
DISTINCTCOUNT(Sales[Store]),
Sales[TotalSale] > 0
)
)
Hope this helps!
If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.
Si funcióna!!
Gracias