Count unique values

[JoseAriel]

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 what function I can use within a measure?

id_no	therapy	next_therapy
A	Ok	2/28/2018
B	Ok	12/6/2017
C	PastDue	6/8/2017
D	DueSoon	10/11/2017
E	PastDue	5/17/2017
F	Ok	1/5/2018

[Ashish_Mathur]

Hi @JoseAriel,

Shouldn't the answer be 2 - there are 2 ID's with an entry of Past due?  Please clarify.

[TomMartens · Accepted solution]

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]

Awesome!! You're right. Should have been 2. I used Count instead of distinct count. Seems to work. Thanks again. I am new to this. Deffinately enjoying the ride. Thanks again.

id_no	therapy	next_therapy
A	Ok	2/28/2018
B	Ok	12/6/2017
C	PastDue
D	DueSoon	10/11/2017
E	PastDue	5/17/2017
F	Ok	1/5/2018

[JoseAriel]

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]

Hi,

Same question posted here.

[JoseAriel]

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"?