DISTINCTCOUNT of a column when true is in another column?

MickeLearnPBI — Mon, 29 Apr 2024 17:22:27 GMT

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

Re: DISTINCTCOUNT of a column when true is in another column?

tamerj1 — Mon, 29 Apr 2024 17:59:26 GMT

MickeLearnPBI

Please try

Count =
SUMX (
SUMMARIZE ( 'Table', 'Table'[PersonID], 'Table'[Task] ),
INT ( CALCULATE ( SELECTEDVALUE ( 'Table'[True/False], FALSE ) = TRUE ) )
)

topic Re: DISTINCTCOUNT of a column when true is in another column? in DAX Commands and Tips

DISTINCTCOUNT of a column when true is in another column?

Re: DISTINCTCOUNT of a column when true is in another column?