Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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.
Keep using Excel, or use separate visuals.
User | Count |
---|---|
102 | |
91 | |
85 | |
77 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |