Forum Discussion

akwang's avatar
akwang
Advocate II
8 years ago
Solved

Count of True / False Issue

Hi So I had posted this issue @ https://community.powerbi.com/t5/Desktop/DAX-IF-Criteria/m-p/488629#M227706   From that i had solved an issue to display in a table visualisation those meeting 3 cr...
Need Help
Tips and Tricks
Tutorial Requests
  • v-cherch-msft's avatar
    v-cherch-msft
    8 years ago

    Hi akwang

     

    You may try to create a measure to get the total as below:

    Measure =
VAR a =
    SUMMARIZE ( Table, Table[Candidate], "a1", [PassOverAl] )
RETURN
    COUNTROWS ( FILTER ( a, [a1] = TRUE () ) )

    Regards,

    Cherie

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
8 years ago

Hi akwang

 

You may try to create a measure to get the total as below:

Measure =
VAR a =
    SUMMARIZE ( Table, Table[Candidate], "a1", [PassOverAl] )
RETURN
    COUNTROWS ( FILTER ( a, [a1] = TRUE () ) )

Regards,

Cherie

akwang's avatar
akwang
Advocate II
8 years ago

WOW that worked!!! Thank you very much v-cherch-msft