topic Counting rows of "1" values depending on the result of a measurement in DAX Commands and Tips

Counting rows of "1" values depending on the result of a measurement

LValencia — Thu, 01 Jun 2023 20:22:23 GMT

Hello,

I have the following measures in a measures table:

TotalPoints = 54890
TotalPointsBlue = 16340
TotalPointsBlueLight =7450

And a "EventPoints" table
Event   Action
event1    1
event2    1
event3    0
event4    1
event5    0
event6    1
event7    0

How can I create a measures that counts the "1" values of the Action column, filtering the records that belong to "TotalPointsBlue"?
I've created this measure, but it does not work
CALCULATE(COUNTROWS(EventPoints), IF(EventPoints[Action] = 1 && [TotalPointsBlue ] > 0, 1, 0)

Plaese, can you help me?

Re: Counting rows of "1" values depending on the result of a measurement

AjithPrasath — Fri, 02 Jun 2023 03:24:29 GMT

LValencia

Try this

CountActionBlue = CALCULATE( COUNTROWS(EventPoints), EventPoints[Action] = 1, EventPoints[Event] IN VALUES(EventPoints[Event]), [TotalPointsBlue] > 0 )

Re: Counting rows of "1" values depending on the result of a measurement

LValencia — Fri, 02 Jun 2023 06:54:33 GMT

Hi AjithPrasath, it doesn't work either.

Error: A placeholder function has been used in a true/false expression that is used as a table filter expression, which is not permitted.