Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
5 years ago
Solved

DAX measure

Hello. I need help!!! I'm having trouble creating a dax measure. I have a table with person ID / appliance status ID / appliance status ID. I want to build a measure that tells me how many people h...
  • amitchandak's avatar
    amitchandak
    5 years ago

    @Syndicate_Admin , Try a measure like

    countx(filter(summarize(TABLE, Table[Id persona], "_1", calculate(count(Table[Id persona]), filter(Table, table[Id appliance]-1 && table[Id state] ?2))
    , "_2", calculate(count(Table[Id persona]), filter(Table, table[Id appliance]-15 && table[Id state] ?3))) , [_1] >0 && [_2] >0 ), [Id persona])

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

@Syndicate_Admin , Try a measure like

countx(filter(summarize(TABLE, Table[Id persona], "_1", calculate(count(Table[Id persona]), filter(Table, table[Id appliance]-1 && table[Id state] ?2))
, "_2", calculate(count(Table[Id persona]), filter(Table, table[Id appliance]-15 && table[Id state] ?3))) , [_1] >0 && [_2] >0 ), [Id persona])

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    5 years ago

    Thanks a lot!!! It was just what I needed!!!