COUNT number of weeks below Budget

[joshua1990]

Hi experts!

I have a simple sales table that is linked with a calendar table.

Now I would like to count the number of weeks - visualized in a matrix - if the sales a below value X.

How is this possible by using a DAX Measure?

[Whitewater100 · Accepted solution]

Hello:

Please see attached link:

https://drive.google.com/file/d/1nSYF-2FkKHMoz2lZtQdBd_V-ijP-A_w7/view?usp=sharing 

It's just several measures:

After sum up Sales and budget:

Budget Variance = [Total Sales] -[Total Budget]

Then

Weeks Under Budget = COUNTROWS(

FILTER(ALL(Dates[Week No]),

[Budget Variance] < 0))

[joshua1990]

Ok, that works fine. But what is, if I want to show the number of weeks above and below the target in the same visual for a selected year?

[Whitewater100]

Yes you can do that. You also can show a weekly column chart calling out the overs/unders. A card visual can show both answers. 

If you have some data, that has multiple years by week and slaes & budget, I can show you.

Is this what you'd like?