Forum Discussion
joshua1990
Post Prodigy
Post ProdigyCOUNTROWS with ALL and FILTER
Hello everybody! I have a table with the following structure linked to my data model: Item Date Value A 01.03.2020 +550 A 02.03.2020 -600 The Date Column is an active connecti...
Perhaps:
Measure = SUMX(FILTER(ALL('Table'),[Value]>500),[Value])Although I can't fathom why you were using COUNTROWS so if you actually want the count, use COUNTX instead of SUMX.
Greg_Deckler
Community Champion
Community ChampionPerhaps:
Measure =
SUMX(FILTER(ALL('Table'),[Value]>500),[Value])Although I can't fathom why you were using COUNTROWS so if you actually want the count, use COUNTX instead of SUMX.