DAX Help count weeks over forecast

Hi Si_7777  

ou can create a DAX measure to count the number of weeks where actual sales exceeded forecast (FC), and display that in a Card visual.

Option A: If your dataset is at week level

Weeks Over FC =
COUNTROWS(
FILTER(
VALUES(Sales[Week]),
CALCULATE(SUM(Sales[Actual])) > CALCULATE(SUM(Sales[Forecast]))
)
)

Option B: If your dataset is at daily level, group by week:

Weeks Over FC =
COUNTROWS(
FILTER(
SUMMARIZE('Date', 'Date'[Week Start], "ActualSales", CALCULATE(SUM(Sales[Actual])), "ForecastSales", CALCULATE(SUM(Sales[Forecast]))),
[ActualSales] > [ForecastSales]
)
)

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!