Count -> New Measure value

[Anonymous]

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 = if([Gap]>0,"Above","Below")

Thanks,

KV's

[VahidDM · Accepted solution]

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  !!

[Ashish_Mathur]

Hi,

If Status is a calculated column in your dataset, then in a Table visual just drag the Status column and write this measure

Count = countrows(data)

Hope this helps.

[Anonymous]

Hi @Ashish_Mathur 
Thanks for your help,

No, Status is new measure.

Thanks,

KV's 

[Ashish_Mathur]

Hi,

Assuming Gap is a calculated column, try these measures:

Status = if(MAX('Table'[GAP])>0,"Above","Below")
Count of above = COUNTROWS(filter('Table',[Status]="Above"))
Count of Below = COUNTROWS(filter('Table',[Status]="Below"))

Hope this helps.