Countrows

[MattC2020]

Hi,

I want to produce a visual that shows in cell in a column that has a value greater than 10 or greater than minus 10. To be honest I`m struggling with this and havent succeeding in getting very far 😞 even after many attempts!

I`ve tried first to see if I can get values greater than 10 with the below formula, but that doesnt seem to work. Any help would be much appreciated! 

countbreak = CALCULATE(COUNTROWS(Accounts),FILTER(Accounts,[Liquidity Fund Difference] >10))

Many Thanks

[Anonymous · Accepted solution]

@MattC2020 

So you want filter the value, greater than 10 or greater than -10?  Did you mean >10 and <-10? And it can be wrong if [Liquidity Fund Difference] a measure, try column if possible.

countbreak = CALCULATE(COUNTROWS(Accounts),FILTER(Accounts,[Liquidity Fund Difference] >10||[Liquidity Fund Difference]<-10)

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@MattC2020 , You need to provide a level or group by in values or summarize where you want the diff should be >10 . something like this

countbreak = CALCULATE(COUNTROWS(Accounts),values(Accounts[Account]),FILTER(Accounts,[Liquidity Fund Difference] >10))

countX(filter(summarize(Accounts,Accounts[Account],"_1",[Liquidity Fund Difference]),[_1]>10),[Account])

I assume account is that row context/level/group by