Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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

  • Anonymous , Try like

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

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you.. That did the trick 🙂

       

      Regards,

      Ashley

  • Hi,

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