Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
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?
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.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
            | User | Count | 
|---|---|
| 8 | |
| 5 | |
| 5 | |
| 4 | |
| 3 | 
| User | Count | 
|---|---|
| 24 | |
| 11 | |
| 10 | |
| 9 | |
| 8 |