Forum Discussion

Celador's avatar
Celador
Frequent Visitor
8 years ago
Solved

DAX - countif after grouping

Hi, I need a series of measures to group some results by two columns and then count specific results in the 3rd column - and I'm very very new to Power BI and DAX. I've done a bunch of googling, re...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Hi Celador

     

    Try these MEASURES as well

     

    Red =
COUNTROWS (
    FILTER (
        SUMMARIZE ( Table1, Table1[UserId], Table1[ResponseId], Table1[Result] ),
        Table1[Result] = "Red"
    )
)

    And

     

    Blue =
COUNTROWS (
    FILTER (
        SUMMARIZE ( Table1, Table1[UserId], Table1[ResponseId], Table1[Result] ),
        Table1[Result] = "Blue"
    )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Hi Celador

 

Just for knowledge sharing. Another way of doing this

 

Blue =
COUNTROWS (
    FILTER (
        ALL ( Table1[UserId], Table1[ResponseId], Table1[Result] ),
        Table1[Result] = "Blue"
    )
)

Similar way for Red

Celador's avatar
Celador
Frequent Visitor
8 years ago

Thanks Zubair_Muhammad - is there any significant performance cost difference between the two solutions?