Forum Discussion

PHEstaciMa1's avatar
PHEstaciMa1
Icon for Helper II rankHelper II
4 years ago
Solved

Looking up values in a column

Hi Everyone, I wanted to seek your help in my current DAX formula,   however, it says "Too many arguments were passed to the COUNTROWS function. The maximum argument count for the function is ...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi PHEstaciMa1 
    Here is the file with solution. https://we.tl/t-dixeoricuZ
    Hope it satisfies your requirement

    Antecedents LSR - Tamer = 
VAR CurrentValue = 
    MAX ( 'Antecedents - LSR'[Value] )
RETURN
    SUMX (
        '2022 Gemba Online',
        IF ( CONTAINSSTRING ( '2022 Gemba Online'[Antecedents], CurrentValue ), 1, 0 )
    )

PHEstaciMa1's avatar
PHEstaciMa1
Icon for Helper II rankHelper II
4 years ago

hi tamerj1 tried but it didnt work.

No figures were shown.

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

PHEstaciMa1 

You can upload the file to OneDrive or WeTransfer and semd the link.