Need to calculate distinct counts based on a measure as a filter DAX

[novice12]

Hi first time posting but have been struggling with this for too long.

I have a large table with the following 

ID | Status

1     Above Budget

2     Below Budget

3     Above Budget

4     Above Budget

The status column is a measure based off the delta between two other columns. It needs to be a measure, as I need this Status calculated dynamically based on the filter/slicer selections on the page.

If I select a table, the measure shows up correctly for each record.

But what I need is a pie chart off this table that would show 75% Above Budget and 25% Below Budget

Since I cannot use measure in the legend of the chart I have tried to create two separate measures, one for Above Budget and another for Below Budget. However, the result I am getting is NOT accurate, I am seeing 4 show up for both Above Budget and Below Budget, likely due to the various granularity of my data.

I have tried various iterations of the below DAX, including sum the forecast and budget but result is always incorrect

Below Budget= calculate(DISTINCTCOUNT([ID]),FILTER(Report,[Forecast]- [Budget]<0))

Any ideas on how to get the correct values to show up?

[Ritaf1983 · Accepted solution]

Hi @novice12 
You can try these 3 measures :

Frcst_Bud_diff =

SUMX('Table','Table'[Forecast]-'Table'[Budget])

Above_budget =

CALCULATE(DISTINCTCOUNT('Table'[ID]),FILTER('Table',[Frcst_Bud_diff]>0))

Below_budget =

CALCULATE(DISTINCTCOUNT('Table'[ID]),FILTER('Table',[Frcst_Bud_diff]<0))

Result:

The PBIX is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.