Forum Discussion

JoseAriel's avatar
JoseAriel
Frequent Visitor
8 years ago
Solved

Count unique values

Hello,   I have a table which I hope to display along with a visualization Card indicating the total count of PastDue values in the therapy column which in this case would be 1. Any thoughts on wha...
Need Help
  • TomMartens's avatar
    TomMartens
    8 years ago

    Hey,

     

    I'm wondering why it's 1, I would count it 2, because there are two unique id_no with the value "PastDue" ,but nevertheless.

    This measure should return 1

    CALCULATE(
DISTINCTCOUNT('yourtable'[therapy])
,'yourtable'[therapy] = "PastDue"
)

    Hopefully this is what you are looking for

     

    Regards

    Tom

JoseAriel's avatar
JoseAriel
Frequent Visitor
8 years ago

Hi,

I have a table with several rows (1 per client). I need to evaluate a column for PastDue Answers. That is, I need to know, of all the clients, how many have PastDue within the given column. I hope to use a visualization Card to display the result (total of answers with the word "PastDue").

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

Same question posted here.

  • JoseAriel's avatar
    JoseAriel
    Frequent Visitor
    8 years ago

    The result worked, however, it leads to another question.

     

    When filtering by worker, some are all up-to-date therfore no "PastDue"s within the column. When that happens, PBI displays (Blank) on the visualizations Card. Any way to have it display 0 instead? Or even "All up to date"?