Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
9 months ago
Solved

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 ...
  • rohit1991's avatar
    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: 

     

     

  • grazitti_sapna's avatar
    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!