Forum Discussion

Chris2016's avatar
Chris2016
Resolver I
3 years ago
Solved

Optimizing performance when using time comparison

Hello,   I have a large dataset where some of the data looks like this: Name Test Activity DateStarted DateCompleted PercComplete Key _TestCompleteDate _CompletedIndividual _TestCo...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Chris2016 

    Please try

    TestCompleteIndividuals =
    COUNTROWS (
    DISTINCT (
    SELECTCOLUMNS (
    FILTER ( 'Table', 'Table'[_TestCompleteUpToLastMonth] = 1 ),
    "@Name", 'Table'[Name]
    )
    )
    )

tamerj1's avatar
tamerj1
Community Champion
3 years ago

Chris2016 

Please try

TestCompleteIndividuals =
COUNTROWS (
DISTINCT (
SELECTCOLUMNS (
FILTER ( 'Table', 'Table'[_TestCompleteUpToLastMonth] = 1 ),
"@Name", 'Table'[Name]
)
)
)