Forum Discussion
Dougers1
2 years agoFrequent Visitor
Help with dAX Formula
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 thinkin...
Fowmy
2 years agoSuper User
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" )
Dougers1
2 years agoFrequent Visitor
Fowmy
Sorry im newto power bi - can you show me a example