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

v-easonf-msft PHEstaciMa1 
My understanding was acutally the opposite. Maybe I'm wrong but I thought PHEstaciMa1 wants to slice by [Value] and count how many times this value occures in the Antecedents list. 
*Update..

Here is v-easonf-msft sample file with my solution https://www.dropbox.com/t/GuXjvUFexvxMNo1H

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 v-easonf-msft I'll have a look at your work first and provide you feedback. yes I wanted to count the occurrences of a particular value in a column which contains other value as well. I'm sharing the PBIX thru this link.

 

PBIX Help Needed 

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

    PHEstaciMa1 
    The link you have shared requires log in with your acount. Did you check my last reply? I have modified v-easonf-msft sample file and re-shared it in the other comment. Please check and let me know if this is what you want. Thank you