Trying to Place a measure in Columns in Matrix as same in Excel

[Rkrama746]

1. Subtotal rows: Bottom 5 rows will be frozen (always displayed) and contain...
   1. An 'Assigned Count' row
      1. Subtotal of each staffer's assigned count of contracts (displayed with filters applied)
   2. A 'Credentialed Count' row
      1. Subtotal of each staffer's credentialed count of contracts (displayed with filters applied)
   3. A 'Disabled Count' row
      1. Subtotal of each staffer's disabled count of contracts (displayed with filters applied)
   4. A 'Non-Credentialed, Valid License' row
   5. A 'Credentialed, Invalid License' row
2. Subtotal Column on right
   1. For each row show subtotals for each contract of...
      1. Total assigned users
      2. Total credentialed users
      3. Total disabled users
3. License Conditional Formatting/Highlighting
   1. For Non-Subtotal Rows...
      1. Highlight green if the respective user has the appropriate license for that contract
      2. Highlight yellow if the respective user lacks the appropriate license for that contract
      3. Highlight red if the respective user lacks the appropriate license for that contract and they have ANY ContractStaff record (regardless of assigned, disabled, credentialed).

Dax is have used is 

Status =
SWITCH (
    TRUE (),
    COUNTROWS(FILTER(ContractStaff, ContractStaff[Assigned] = TRUE())) > 0 && COUNTROWS(FILTER(ContractStaff, ContractStaff[Disabled] = FALSE())) > 0, "A",
    COUNTROWS(FILTER(ContractStaff, ContractStaff[Assigned] = FALSE())) > 0 && COUNTROWS(FILTER(ContractStaff, ContractStaff[Disabled] = FALSE())) > 0, "C",
    COUNTROWS(FILTER(ContractStaff, ContractStaff[Disabled] = TRUE())) > 0, "D",
    BLANK()
)

I need to display the count of total A,C,D in the same matrix regards to the Staffname your help will be much appricated.thanks

i have acheived this upto some extent need  get those assigned count and disable count in the above image 

@Greg_Deckler @amitchandak @lbendlin @v-yangliu-msft 

[Anonymous]

Hi, @Rkrama746 

To display a subtotal of assigned, voucher, and disabled contract counts for each employee, you can create measures for each category. For example, for an assigned count, you can use a measure similar to the following:

Assigned Count = 
SUMX(
    FILTER(
        ContractStaff,
        ContractStaff[Assigned] = TRUE()
    ),
    ContractStaff[AssignedCount] // Assuming you have a column that captures the count
)

To display the count of total "A", "C", "D" statuses next to the staff name, you can create additional measures that count these statuses. 

Count of A = 
CALCULATE(
    COUNTROWS(ContractStaff),
    FILTER(
        ContractStaff,
        [Status] = "A"
    )
)

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Keep using Excel, or use separate visuals.