Forum Discussion
Helper IILooking up values in a column
Hi PHEstaciMa1
Here is the file with solution. https://we.tl/t-dixeoricuZ
Hope it satisfies your requirementAntecedents LSR - Tamer = VAR CurrentValue = MAX ( 'Antecedents - LSR'[Value] ) RETURN SUMX ( '2022 Gemba Online', IF ( CONTAINSSTRING ( '2022 Gemba Online'[Antecedents], CurrentValue ), 1, 0 ) )
Community SupportHi, PHEstaciMa1
The 'Max' should be used for the first parameter in 'CONTAINSSTRING', please modify your original formula as below:
M_Antecedents LSR =
COUNTROWS (
FILTER (
ALL('Antecedents - LSR'),
CONTAINSSTRING (
MAX('2022 Gemba Online'[Antecedents]) ,
'Antecedents - LSR'[Value]
)
)
) + 0
Please check my sample file for more details.
Best Regards,
Community Support Team _ Eason
- tamerj1
Community Champion
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 ) )
PHEstaciMa1Hi 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.
- tamerj1
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
- PHEstaciMa1
tamerj1 do you still have the pbix file? I can't access in your dropbox. thanks
- tamerj1
I guess so. Let me check it up and forward it to you