Forum Discussion

brettg's avatar
brettg
Helper II
4 years ago
Solved

Grouping test count

Hello,   I currently have a table populated with values, 1,2,3.. etc.     I am counting repeat test users with the following;   Count = CALCULATE(COUNTROWS('Table'),FILTER(ALLSELECTED('...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, brettg;

    Try to enter a table.

    Create a column 

    Test2 = [start]&"-"&[end]

    then create a measure.

    Count(again based on meassure2) = 
var _t=SUMMARIZE('Table','Table'[UserID],"Count by UserID",[Count])
return COUNTROWS(FILTER(_t,[Count by UserID]<=MAX('Table (2)'[end])&&[Count by UserID]>=MAX('Table (2)'[start])))+0

     The final output is shown below:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, brettg;

Try to enter a table.

Create a column 

Test2 = [start]&"-"&[end]

then create a measure.

Count(again based on meassure2) = 
var _t=SUMMARIZE('Table','Table'[UserID],"Count by UserID",[Count])
return COUNTROWS(FILTER(_t,[Count by UserID]<=MAX('Table (2)'[end])&&[Count by UserID]>=MAX('Table (2)'[start])))+0

 The final output is shown below:


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

brettg's avatar
brettg
Helper II
4 years ago

Hi v-yalanwu-msft 

 

This is perfect - thank you! 🙂