Forum Discussion

Nagin's avatar
Nagin
Frequent Visitor
4 years ago
Solved

Countrows ALL

Hi All,   I am trying to create a measure to countrows and ignore all slicer filters, to enable me to calculate a % rate, so for example in the image below, the % calculation is working fine as no ...
  • v-jianboli-msft's avatar
    v-jianboli-msft
    4 years ago

    Hi Nagin ,

     

    Based on your description, I have created a simple sample:

    Please try:

    ALL = COUNTROWS(FILTER(ALL('Table'),'Table'[MonthAndYear]=MAX('Table'[MonthAndYear])))

Percentage = DIVIDE(COUNTROWS('Table'),[ALL])

    Final output:

    Best Regards,

    Jianbo Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

ValtteriN's avatar
ValtteriN
Community Champion
4 years ago

Hi,

I am not sure I follow but here are a few examples:

Data:

 


ALL rows of a table:

Measure 19 = COUNTROWS(ALL(Category))

rows of all selected:

Measure 20 = COUNTROWS(Category)

Percentage is just DIVIDE([m 20], [m 19])

End result:

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/