Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi!
I have a column that can have the same value twice or more, but when the value in this column is the same and it is true in column True/False, how can I count the unique values for that person per task? Or rather the unique task per person?
112233 Is working on two tasks and is Admin on both, both the value is true becuase i only want to count this as one (Admin).
334455 Is only working on one task = true
445566 Is working on two tasks = false
The name of the task is fictitious and may vary.
Do you have any suggestions?
Example
PersonID | Task | True/False (Unique value) |
112233 | Admin | True |
112233 | Admin | True |
334455 | Economy | True |
445566 | Economy | False |
445566 | Sales | False |
Solved! Go to Solution.
Please try
Count =
SUMX (
SUMMARIZE ( 'Table', 'Table'[PersonID], 'Table'[Task] ),
INT ( CALCULATE ( SELECTEDVALUE ( 'Table'[True/False], FALSE ) = TRUE ) )
)
Please try
Count =
SUMX (
SUMMARIZE ( 'Table', 'Table'[PersonID], 'Table'[Task] ),
INT ( CALCULATE ( SELECTEDVALUE ( 'Table'[True/False], FALSE ) = TRUE ) )
)
User | Count |
---|---|
60 | |
22 | |
18 | |
18 | |
16 |
User | Count |
---|---|
86 | |
54 | |
54 | |
38 | |
21 |