Grouping ID in single or multiple categories

[Anonymous]

Hi All, 

I need help to group ID's which appear in single or multiple categories. 
Attaching an image which has sample dataset and the result expected. 
We can't harder -code the ID's and Categories as the original dataset is dynamic in nature. 

 The last column in expected result is not required, its just for explanation purpose. 

Thanks 

[wdx223_Daniel · Accepted solution]

[wdx223_Daniel · Accepted solution]

[CNENFRNL · Accepted solution]

Impacts more than 1 Category = DISTINCTCOUNT( 'DATASET'[ID] ) - [Impacts 1 Category]