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.

     

v-jianboli-msft's avatar
v-jianboli-msft
Community Support
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.