Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

COUNTIFS occurrence sensor values DAX

Good morning all, My request concerns the programming of a measure. As you can see on the image below :  I have a table with 3 columns: DT10 min (Time of reading the value of the sensor); Sen...
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Try new meaures like

     

    value occurrence =countx(filter(allselected(Table), Table[value]>=Table[Value]),Table[Value])


    occurrence % = divide(countx(filter(allselected(Table), Table[value]>=Table[Value]),Table[Value]),countx(allselected(Table),Table[Value]))

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

Anonymous , Try new meaures like

 

value occurrence =countx(filter(allselected(Table), Table[value]>=Table[Value]),Table[Value])


occurrence % = divide(countx(filter(allselected(Table), Table[value]>=Table[Value]),Table[Value]),countx(allselected(Table),Table[Value]))