Global Power BI User Group

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.

Filter a result that excludes more than one row

  • 1.  Filter a result that excludes more than one row

    Silver Contributor
    Posted Jul 25, 2019 09:56 AM
    HI

    i have two tables

    table a

    id  name
    1    MOD1
    2  MOD2


     table b

    name result
    mod1 4
    mod2 4
    mod1 3

     i want to count on id where the result  = 4  and result <> 3 ,  currently my dax returns 2 but i only want it to return one , obviously this doesn't work how do i first bring back a subset by excluding all the id's that dont have 3, so that it only does a count on that subset?  does that make sense?

    ie calculate (count(id), filter(tableb, result = 4 && result <> 3)

    ------------------------------
    Vanessa van Gelder
    BI Consultant / Contractor
    Lwazi Data
    Portsmouth
    7707861535
    ------------------------------