Forum Discussion

Jadegirlify's avatar
Jadegirlify
Helper I
2 years ago
Solved

Distinct Count Help

I have a table showing Issues and Location. I need to show a count of unique location by Issue. I need help creating a measure or calculated column for to make a result table like the 2nd table. Wire...
Need Help
Tips and Tricks
  • vicky_'s avatar
    vicky_
    2 years ago

    Hi - try use a matrix / table, add the Issue as a row value and then create a measure like:

    Count of Location = COUNTROWS(VALUES(Table[Location]))

     

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Jadegirlify ,
    I’d like to acknowledge the valuable input provided by the VahidDM   and vicky_  .
    Here are more  steps I want to add:
    First, you can use filed aggregation

    Or you can create a measure

    Count of Lcation = CALCULATE( DISTINCTCOUNT('Table'[Location]), ALLEXCEPT( 'Table', 'Table'[Issue] ) )



    Best regards,
    Albert He

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

     

Khushidesai0109's avatar
Khushidesai0109
Skilled Sharer
2 years ago

Hiii Jadegirlify 

Here is the Dax measure you can use for the desired output

 

 

Count of Location = DISTINCTCOUNT('Table'[Location])


 
 
 
 
 
 
 
 
 
If this solution helped you please give thumbs up and accept it as solution!!!