Countrows with allselected filter

[Anonymous]

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.

[Ashish_Mathur]

Hi,

Is [Count of Result] a measure?  Share the link from where i can download your PBI file.

[amitchandak · Accepted solution]

@Anonymous , Try like

calculate([count of result], allexcept(Table, Table[Title]))

[Anonymous]

Thank you.. That did the trick 🙂

Regards,

Ashley