Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
LValencia
New Member

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

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?

 

 

2 REPLIES 2
AjithPrasath
Resolver II
Resolver II

@LValencia 

 

Try this

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

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.

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

Top Solution Authors