Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to Take Count and Distinct Count Dependent on Column Value

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 Va...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    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
Anonymous's avatar
Anonymous
Not applicable
5 years ago

HI Anonymous 

 

You can try 
_count = 
Switch(TRUE(),

            'A',COUNT(COL),

            'B',DISTINCTCOUNT(COL),

            'C',COUNT(COL))

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

     

    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