Forum Discussion

DHB's avatar
DHB
Icon for Helper V rankHelper V
2 years ago
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...
Need Help
  • Ahmedx's avatar
    Ahmedx
    2 years ago

    you need to just use COUNTROWS functions

    measure =

    COUNTROWS( 'your'table)+0
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

Hi,

Write this measure

Measure = calculate(countrows(Dates),Dates[Valid]="Valid")

Hope this helps.

DHB's avatar
DHB
Icon for Helper V rankHelper V
2 years ago

Thank you Ashish_Mathur that works well.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    2 years ago

    You are welcome.