Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Count -> New Measure value

Hi Team,   I have done status column and next I want to count based on status column values for trend analysis.   I want the count of "Above" and "below" separatly.    (New Measure) Status = i...
Need Help
  • VahidDM's avatar
    VahidDM
    5 years ago

    Hi Anonymous 

    Try these measures:

    Status = if(MAX('Table'[GAP])>0,"Above","Below")

Count of above = CALCULATE(COUNTROWS('Table'),filter('Table',[Status]="Above"))

Count of Below = CALCULATE(COUNTROWS('Table'),filter('Table',[Status]="Below"))

     

    The outout would be as follow:

    Did I answer your question? Mark my post as a solution!

    Appreciate your Kudos  !!

VahidDM's avatar
VahidDM
Super User
5 years ago

Hi Anonymous 

Try these measures:

Status = if(MAX('Table'[GAP])>0,"Above","Below")

Count of above = CALCULATE(COUNTROWS('Table'),filter('Table',[Status]="Above"))

Count of Below = CALCULATE(COUNTROWS('Table'),filter('Table',[Status]="Below"))

 

The outout would be as follow:

Did I answer your question? Mark my post as a solution!

Appreciate your Kudos  !!