Greater than, less than and equal to a single column values

[tanveer4m]

Hi Everyone,

I am trying to calculate how many values are greater than 12 and lessser than 12 and equals to 12 from a single column.

Table is having numbers ranging from 1 to 40 on a single column.

I have seen the dmax formula as creating filters less than and greater than these two works perfectly but when I apply third catagory that is equals to 12. Formula error occurs and says this is reoccurring to previous filters. I am stuch with this.

I can easily archive the above in excel by applying countif, since this is not available in power bi I am struggling how to achieve this.

Could anyone please help me out.

[tanveer4m]

The chart which is prepared by applying the above dmax code, is static and does not interact with other charts present in the dashboard.

[FreemanZ · Accepted solution]

hi @tanveer4m 

you would need multiple measures like:

Above12 =

COUNTROWS(FILTER(ALL(TableName), TableName[Value]>12)

Equal12 =

COUNTROWS(FILTER(ALL(TableName), TableName[Value]=12)

Below12 =

COUNTROWS(FILTER(ALL(TableName), TableName[Value]<12)

[tanveer4m]

Thanks @FreemanZ  exactly what i was looking to accomplish