Forum Discussion

abukapsoun's avatar
abukapsoun
Post Patron
9 years ago
Solved

Count value in different columns

Hi All,   I am very new to Power BI and still exploring it.  Suppose we have the following Excel table   Name    Country       Comp1    Col2     Col3 A              X                 cs        p...
  • v-jiascu-msft's avatar
    v-jiascu-msft
    9 years ago

    Hi abukapsoun,

     

    If this is the only problem, I would suggest to use a new function "DISTINCTCOUNT".

    Measure =
DISTINCTCOUNT ( Table1[Name] )

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Because only keeping one row would lead another problem that the connection between "country" and "value" would be broken. (the data in red rectangle belongs to no country.)

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale