Forum Discussion

ignas's avatar
ignas
Advocate II
5 years ago
Solved

Count distinct values Issue with non unique

Hello I have a simple issue: Source table Aggregated table: How to get only a count for a link that has a non-null value? In  this case, I should get 3: link1+link2+link4=3 Power BI ...
Need Help
Show and Tell
Tips and Tricks
  • themistoklis's avatar
    themistoklis
    5 years ago

    ignas 

     

    try the following formula:

     

    countdistinctnonblank = CALCULATE(DISTINCTCOUNTNOBLANK(emails[link]), emails[link]<>"" && NOT ISBLANK(emails[link]))
themistoklis's avatar
themistoklis
Community Champion
5 years ago

ignas 

 

try the following formula:

 

countdistinctnonblank = CALCULATE(DISTINCTCOUNTNOBLANK(emails[link]), emails[link]<>"" && NOT ISBLANK(emails[link]))