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

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, PHEstaciMa1 

If your problem has been solved, please accept the reply as solution to close this thread, so that other community members will easily find the solution when they get the same issue.

If you still need help, please share more details.

Best Regards,
Community Support Team _ Eason

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

    Hi v-easonf-msft sorry, I had issues in my software last week. I tried your advise but it showed an error.

    I'm trying to look for ways on how can I share my PBIX until now. Hopefully I can find a way.

     

      • tamerj1's avatar
        tamerj1
        Icon for Community Champion rankCommunity Champion
        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 )
    )