topic Re: How to count number of rows on a measure which gives true or false value? in DAX Commands and Tips

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

rahulvyas — Fri, 22 Apr 2022 17:35:49 GMT

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.

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

tamerj1 — Fri, 22 Apr 2022 17:40:29 GMT

Hi rahulvyas

you my try

SUMX (

VALUES ( Table[PostDate] ),

CALCULATE (

IF (

[Cash_Holding_Over_Under] = TRUE (),

)

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

rahulvyas — Fri, 22 Apr 2022 17:52:13 GMT

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

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

tamerj1 — Fri, 22 Apr 2022 18:18:38 GMT

rahulvyas

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

you my try

SUMX (

VALUES ( Table[PostDate] ),

[Cash_Holding_Over_Under]

)