Table with 2 columns where only one column is filtered

[gbaia]

Hi all, 

I'm creating a table that has the 'count' of 'cases' (case ID) by relationship status. I want one column to give the total, and one column to be filtered by 'project' - project is another field of the cases table. 

Ideally I'd have something like below, a drop-down with Projects above the report, and when a project is selected the second column below changes - this would then make it easy to compare how many on a project when comparing to the total.

Is this possible? I've managed to have the drop-down, but everything on the page gets filtered by it 😕

Thank you so much!

Status	Count	Count filtered by project
Married	560	200
Single	300	40
Divorced	250	50
Widowed	10	3
Other	25	0

[DataInsights · Accepted solution]

@gbaia,

Try these measures:

Count = CALCULATE ( COUNT ( 'Cases'[Case ID] ), ALL ( 'Cases'[Project] ) )

Count Filtered by Project = COUNT ( 'Cases'[Case ID] )

-----