Forum Discussion

damtran's avatar
damtran
Regular Visitor
3 years ago
Solved

Indicate New vs Existing Customer

Hi everyone, I'd like to ask for help in this case: - Table has 3 columns: Customer, Revenue, and Year - Some customers have revenue in both 2022 and 2023 = Existing, some just have revenue in 202...
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi damtran 

    try to replace:
     
    COUNTROWS(
        FILTER(
           _table,
            TableName[Year] = _currentyear
        )
    )
     
    with:
     
    COUNTROWS(
        CALCULATETABLE(
           SUMMARIZE(_table, TableName[ClientID])
            TableName[Year] = _currentyear
        )
    )
     
    other parts are similar.
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi damtran 

try to replace:
 
COUNTROWS(
    FILTER(
       _table,
        TableName[Year] = _currentyear
    )
)
 
with:
 
COUNTROWS(
    CALCULATETABLE(
       SUMMARIZE(_table, TableName[ClientID])
        TableName[Year] = _currentyear
    )
)
 
other parts are similar.
damtran's avatar
damtran
Regular Visitor
3 years ago

Thank you so much FreemanZ , you help me save a lot of time!!!!!!!!!!