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]))

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi amitchandak and thank you but the measure is not working. Here is the result I get:

For more information on my file, I attach below the code of the "Sensor value" measurement :

I also attach the architecture of my Dataset to make it more understandable:

Thank you in advance for your help