How to Take Count and Distinct Count Dependent on Column Value

[Anonymous]

In my data set I need to take a count or distinct count of a unqiue ID depending on a column value.  In the below example, if the Value is A or C I need to take a count of the Unique ID and if the Value is B I need to take a distinct count.  The Expected Result is what I would need the data to be represented as in a single visualization.  Any help would be greatly appreciated as I keep going in circles.

Data Example
Value	ID	Unique ID	Count Type
A	12345	A12345	Count
A	12345	A12345
A	12345	A12345
B	13579	B13579	Distinct
B	13579	B13579
B	54321	B54321
B	54321	B54321
B	97531	B97531
C	11223	C11223	Count
C	99887	C99887

Expected Result
Value	Total
A	3
B	3
C	2

[pranit828]

Hi @Anonymous 

Use matrix chart instead of table chart

Or

Create is as a column instead of measure.

[Anonymous · Accepted solution]

Hi @pranit828 ,

I took what you provided and was able to tweak it a little to get what I needed.  Here is where I ended up at when creating the measure.  Thanks for the assistance.

Count =

SWITCH( SELECTEDVALUE('Table'[Value]),

"A", COUNT('Table'[Unique ID]),

"B", DISTINCTCOUNT( 'Table'[Unique ID]),

"C", COUNT('Table'[Unique ID]))

Regards,

Eric

[pranit828]

HI @Anonymous 

You can try 
_count = 
Switch(TRUE(),

            'A',COUNT(COL),

            'B',DISTINCTCOUNT(COL),

            'C',COUNT(COL))

[Anonymous]

Hi @pranit828 ,

I am able to create a measure with the formula suggested, but when adding the measure to a visual I receive the following error "Function 'SWITCH' does not support comparing values of type True/False with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values."

Regards,

Eric