Forum Discussion
Measure with filter
- 9 months ago
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: - 9 months ago
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!
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