topic Re: Help with dAX Formula in DAX Commands and Tips

Help with dAX Formula

Dougers1 — Sat, 25 Nov 2023 18:51:20 GMT

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" )

Re: Help with dAX Formula

Fowmy — Sat, 25 Nov 2023 19:32:46 GMT

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" )

Re: Help with dAX Formula

Dougers1 — Sat, 25 Nov 2023 20:05:18 GMT

Fowmy

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

Re: Help with dAX Formula

Fowmy — Sun, 26 Nov 2023 06:35:39 GMT

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.