Measure with filter

[AllanBerces]

Hi can anyone help on my measure count

1 . Alert 3 = X

2. Progress Pref = 0

3. Progress Inst is less than 100

RESULT

Job Prefab	Progress Pref.	Progress Inst.	Alert 3
LS2287	0	0
LP2163	0	0	X
LP2640	0	0	X
LP2640	0	0	X
P2195	0	0	X
LP2195	0	0	X
LS2000	0	100	X
LS2000	0	69.8	X
LS2000	0	100	X
LS2000	0	27.12	X
LS2000	0	0	X
LS2181	0	0
LS2302	0	0	X
LS2221	0	0	X
LS2220	0	0	X
LS2194	0	0	X
1LS2217	100	100	X
LS2017	100	100	X
LS2034	100	44.74	X
LS2033	100	44.74	X
LS2030	100	100	X
LS2218	100	79.9	X
LS2041	100	100	X
LS2268	100	0	X
LS2448	100	0	X

[rohit1991 · Accepted solution]

Hi @AllanBerces 

Create the measure below and replace 'Sample Data' with the actual name of your table:

Alert3_Count = 
CALCULATE(
    COUNTROWS('Sample Data'),
    'Sample Data'[Alert 3] = "X",
    'Sample Data'[Progress Pref] = 0,
    'Sample Data'[Progress Inst] < 100
)

 Outcome: 

[grazitti_sapna · Accepted solution]

Hi @AllanBerces,

If i've understood correctly, you want to row count where all these 3 mentioned conditions are true and row count should be 12.

Kindly elaborate more if that's not the requirement.

Attached is the .pbix file with solution.

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!

[rohit1991 · Accepted solution]

Hi @AllanBerces 

Create the measure below and replace 'Sample Data' with the actual name of your table:

Alert3_Count = 
CALCULATE(
    COUNTROWS('Sample Data'),
    'Sample Data'[Alert 3] = "X",
    'Sample Data'[Progress Pref] = 0,
    'Sample Data'[Progress Inst] < 100
)

 Outcome: 

[AllanBerces]

Hi @grazitti_sapna @rohit1991 thank you very much, working as i need