Forum Discussion
Measure with filter
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 |
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: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!
3 Replies
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:Hi grazitti_sapna rohit1991 thank you very much, working as i need
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!