Forum Discussion

cottrera's avatar
cottrera
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

DAX count blank results

Hi 

 

I have a table visual with teams i the rows and a measure calculating two sets of results Good and Bad.

I would like to a new measure that counts the number of teams that have no results from the Good measure and place this result in a card visual.

 

TeamGood (DAX measure)Bad (DAX measure)
A3012
B245
C4056
D 25
E 23
F 23
G33

 

thank you

 

RIchard

Need Help
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    Hi cottrera ,

     

    create a measure like below:-

    measure = calculate(count(table[teams],[Good] = BLANK())

     

    Thanks,

    Samarth

2 Replies

  • Samarth_18's avatar
    Samarth_18
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi cottrera ,

     

    create a measure like below:-

    measure = calculate(count(table[teams],[Good] = BLANK())

     

    Thanks,

    Samarth

  • cottrera's avatar
    cottrera
    Icon for Post Prodigy rankPost Prodigy
    4 years ago

    Hi Samarth 
    thank you for coming back so quickly. Appologies I probably did not explain my question  clearly.

     

    I have a large data set roughtly like this one.

    TeamYearResult
    A2020Good
    A2021Bad
    A2022Good
    A2021Good
    A2021Bad
    B2020 
    B2021Good
    B2021Good
    B2021Good
    B2021 
    C2020Bad
    C2021Bad
    C2019Bad
    C2021Good
    C2021Bad
    D2020Good
    D2021Bad
    D2019Bad
    D2021Good
    D2021Bad
    E2020Good
    E2021Bad
    E2019Bad
    E2021Bad
    E2021Good
    F2020Good
    F2021Good
    F2019 


    I have then pulled this data into the table 

     

    And summarised like this


    TeamGoodBad

    A23
    B 3
    C41
    D32
    E32
    F 4
    G23

     

    Its at this point I need a measure to count the blanks by team for good.

     

    Thanks

     

    Richard