Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Get count values for comma separated

Hi, I have a table below. Tenant ID will always be unique. I need a measure for Incident Type, Priority, and Incident Root cause to get the result below.   Table :   Result expected : ...
DAX
Measures
Need Help
FreemanZ's avatar
FreemanZ
Super User
3 years ago
This shall be achieveable without any DAX code:
For the incidents by type table, create a table visual, put the [Incident Type] and [TelantID] to the Columns. Then you will get the expected result. 
 
It is similar to the other two tables. 
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi FreemanZ ,

    This will not work. I need count for every value present in Incident Type 
    Ex: Near miss is present for all three tenant ID, so count of near miss should be 3.

     

    • FreemanZ's avatar
      FreemanZ
      Super User
      3 years ago

      Aha, then you need to split [Incident Type] column and duplicate the rest columns first in Power Query. For example, a row with 3 incident types, there will be 3 rows. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        I do not want to go with that approach since I will have 40 more comma-separated columns with different values.

        So I need a calculated measure.
        Thank You!

         

        amitchandak Greg_Deckler Jihwan_Kim  Please help