Scorecard to show total count based on filtered total for category, not total rows

[jbach]

Hi Everyone.

I'm currently trying to do a dashboard for my departments KPIs

I have a dataset that looks like this

My report looks something like this

 

My issue now is:

I can't get the second scorecard to show total number of initiatives that have a total 'PROGRESS 2' of less than 50

(My initial assumption was that it has to do with a failure of the filters taking into consideration of the context transition..)

I've tried putting 'Filters on this Visual' on the scorecard with 'PROGRESS 2' showing items when the value is less than 50 but it still shows as 8.

The scorecard that shows 'blank' has this measure:

COUNTX(VALUES(Table7[INITIATIVE 2]),CALCULATE([Countx],FILTER(Table7,Table7[PROGRESS 2]<50)))

[Countx] =

COUNTX(Table7,COUNT(Table7[INITIATIVE 2]))

I'm completely lost on how to get this to work. Appreciate any help I can get on this. Please and thank you!

[v-xiaoyan-msft]

Hi @jbach ,

Please correct me if I have misunderstood your requirements
Do you want the chart below to display normally or do you want to filter by subcategory
Yes please take a look at this thread below, is your requirement similar to this user?

Solved: Category based Cumulative total and ABC segmentati... - Microsoft Power BI Community

Best Regards,
Community Support Team _ Caitlyn