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 )
    )

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

Hi PHEstaciMa1 

you may try

Antecedents LSR =
COUNTROWS (
    FILTER (
        '2822 Gemba Online',
        '2022 Gemba Online'[Antecedents] IN VALUES ( 'Antecedents LSR'[Value] )
    )
)
  • 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. 

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

      PHEstaciMa1 
      Just double checked with dummy data. The code is working. What are you slicing by? I guess you should be slicing by 'Antecedents LSR'[Value] in order to see the count related to each value. Am I missing something?