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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

PHEstaciMa1 , better to create a new column in table1

 

countx(filter(Table2, Containsstring(Table2[Antecednet], Table1[Value]) ), Table2[Antecednet])

 

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

 

Then you can sum

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

Hi amitchandak  I'm trying to share the PBIX but it seems there is no option in the reply to attached files. Where can I send it?

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    PHEstaciMa1 , you can upload on onedrive or dropbox and share the link

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

      Hi amitchandak tamerj1 I'm sharing to both of you my PBIX file, removed the sensitive information already. You may access the file here. 

       

      PBIx Help Needed