Forum Discussion
DHB
2 years agoHelper V
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...
- 2 years ago
you need to just use COUNTROWS functions
measure =
COUNTROWS( 'your'table)+0
Ashish_Mathur
2 years agoSuper User
Hi,
Write this measure
Measure = calculate(countrows(Dates),Dates[Valid]="Valid")
Hope this helps.
DHB
2 years agoHelper V
Thank you Ashish_Mathur that works well.
- Ashish_Mathur2 years agoSuper User
You are welcome.