Forum Discussion

Dougers1's avatar
Dougers1
Frequent Visitor
2 years ago

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

3 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    2 years ago

    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's avatar
      Dougers1
      Frequent Visitor
      2 years ago

      Fowmy

       

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

    • Fowmy's avatar
      Fowmy
      Super User
      2 years ago

      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.