Forum Discussion
Anonymous
5 years agoNot applicable
Countrows with allselected filter
Hi,
I need help.. I have the table like below. What I would like to do is to count the values in "Count of Result" column filtered by the "Title" column.
So in the Measure column, I would like to expect the value for title 16003061847 to be "62" and for 1600306789181 to be "4"
Currently the Measure formula I am using is ;
COUNTROWS(filter(ALLSELECTED('Test'),RIGHT('Test'[SRNO],2)<>".0"))
Any help would be much appreciated.
Thank you.
Anonymous , Try like
calculate([count of result], allexcept(Table, Table[Title]))
3 Replies
- amitchandakSuper User
Anonymous , Try like
calculate([count of result], allexcept(Table, Table[Title]))
- AnonymousNot applicable
Thank you.. That did the trick 🙂
Regards,
Ashley
- Ashish_MathurSuper User
Hi,
Is [Count of Result] a measure? Share the link from where i can download your PBI file.