Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
Solved! Go to 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
Hi @JoseAriel,
Shouldn't the answer be 2 - there are 2 ID's with an entry of Past due? Please clarify.
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
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 |
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").
Hi,
Same question posted here.
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"?
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |