How to count number of rows on a measure which gives true or false value?

[rahulvyas]

I have created true or false measures out of a 2 different measure 

For example: Cash holding if(measure1>measure2, 0,1). 

I am trying to count how many numbers of 1 we got as a card visual but nothing seems to be working. Does anyone have any other way? When I select the Card visual it does not give the proper count. 

[tamerj1]

Hi @rahulvyas 

you my try

SUMX ( 

VALUES ( Table[PostDate] ),

CALCULATE (

IF (

[Cash_Holding_Over_Under] = TRUE (), 

1

)

)

)

[rahulvyas]

Does not work. Getting the error. I also check the format and its a "Whole Number"

[tamerj1 · Accepted solution]

@rahulvyas 

I thought you said true/false output. No issues. Try

you my try

SUMX ( 

VALUES ( Table[PostDate] ),

[Cash_Holding_Over_Under]

)