Forum Discussion
Solved
Counting Values in a Joined Table
Hi all, could anyone give me an idea how to count rows in a joined table please? I have a table of people (all unique records) joined to a table of dates (each person/date combination is uniq...
you need to just use COUNTROWS functions
measure =
COUNTROWS( 'your'table)+0
Ahmedx thank you so much for your solution. How could I change it to only count dates that are "VALID" according to another column?
So if the Dates table now looked like this:
| PERSON | DATE | VALID |
| 1234_ABC | 1/01/2020 | VALID |
| 1234_ABC | 2/01/2020 | VALID |
| 1234_ABC | 3/01/2020 | INVALID |
| 1255_ABC | 1/01/2020 | VALID |
| 1234_CDE | 1/01/2020 | VALID |
| 1234_CDE | 2/01/2020 | VALID |
| 1234_CDE | 3/01/2020 | INVALID |
| 1234_CDE | 4/01/2020 | INVALID |
| 1234_CDE | 5/01/2020 | INVALID |
| 1234_CDE | 6/01/2020 | INVALID |
| 1344_XYZ | 1/01/2020 | VALID |
| 1344_XYZ | 2/01/2020 | VALID |
And the result should now look like this;
| PERSON | DATE COUNT |
| 1234_ABC | 2 |
| 1255_ABC | 1 |
| 1234_CDE | 2 |
| 1344_XYZ | 2 |
| 1499_MMM | 0 |
Hi,
Write this measure
Measure = calculate(countrows(Dates),Dates[Valid]="Valid")
Hope this helps.
Thank you Ashish_Mathur that works well.
You are welcome.
