DAX: How to calculate number of occurences in a dataset

[Anonymous]

Hi,

I have a column with difference % values. I want to create a measure that will tell me how many of those values are greater than 50%. Can anyone advise how to do that?

Thanks,

NB1

[Anonymous · Accepted solution]

When you get that error you have to include FILTER in the CALCULATE function.

You can still use @Zubair_Muhammad's measure, but you just need some adjustment:

Measure =
CALCULATE ( COUNTROWS ( TableName ), FILTER(TableName, TableName[column] > .5 ))

[bikram_laishram · Accepted solution]

Hello,

what is the current format of the column. Create a calculated column using "New Column = tablename[column). Please change the column to decimal or whole number. then you can use '
Measure =
CALCULATE ( COUNTROWS ( TableName ), TableName[column] > .5 )
as suggested by Zubair_Muhammad

[Zubair_Muhammad]

@Anonymous

Try with following

Measure =
CALCULATE ( COUNTROWS ( TableName ), TableName[column] > .5 )

[Anonymous]

@Zubair_Muhammad thanks, however i'm still getting an error message: "A function CALCULATE has been used in a True/False expression that is used as a filter table expression. This is not allowed."

The column I want to filter by values that are >/< 50% is itself a calculated column. Does that change the DAX formula that needs to be used?

[Anonymous · Accepted solution]

When you get that error you have to include FILTER in the CALCULATE function.

You can still use @Zubair_Muhammad's measure, but you just need some adjustment:

Measure =
CALCULATE ( COUNTROWS ( TableName ), FILTER(TableName, TableName[column] > .5 ))

[Zubair_Muhammad]

@Anonymous

No it shouldn't matter if its a column or a calculated colum

Did you add the Formula as a MEASURE or calculated column

Could you show me the screen shot of your Table?