Help with dAX Formula

[Dougers1]

im lookin to  get the total amount of agency unfilled, problem i have is that the Agency column has several agency names in the Agency Column

how do i get it to return total unfilled Also thinking ahead, what would the formula also be  to see what specific Agency  had unfilled

Agency Unfilled = CALCULATE( COUNTROWS('Interpreting') , 'Interpreting'[Agency] , 'Interpreting'[status] = "Unfilled" )

[Fowmy]

@Dougers1 

Add the Agencies on the Row Section of a matrix and add the following measure to value, it will show you by agencies:

Agency Unfilled = CALCULATE( COUNTROWS('Interpreting') ,'Interpreting'[status] = "Unfilled" )

[Fowmy]

@Dougers1 

If you could share a Power BI file with some dummy data to show your scenario, then I will be able to demonstrate the solution to you. Save the file in Google Drive and share the link here and grant access to the file.

[Dougers1]

Fowmy

Sorry im newto power bi -  can you show me a example