Forum Discussion
SUM values filtered by another column
Hello, I have been using Power BI for some time but I now run into an issue I don't know how to solve yet. So I have a table like this: Code OH NOH 125 1 0 125 1 0 125 1 ...
Count OH=
Hi Anonymous
VAR _Code = SELECTEDVALUE(TABLE[CODE])
VAR _RESULT = CALCULATE(COUNT(TABLE[OH]), TABLE[CODE] = _Code)
RETURN
_RESULT
do the same for NOH
But i think you want to see the SUM and not the COUNT. if so replace Count by SUM.
For some reason the provided possible solution didn't solve the problem. What I've done is, use the standard Count and Distinct Count option in Power BI.
aj1973
Community Champion
Community ChampionDid you use SUM instead?
Can you share your file?
Is your porblem solved?