Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Count if values

Hello to all, I ask for your help concerning a measurement of type "IF". I would like to display "1000" when the value of the measurement "Digester level (m)" reaches the value of 6 then continue t...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

Anonymous The problem is clear, and it is a nice one.  Powert BI is really bad at hysteresis  (it has no memory) but I think with a bit of DAX trickery this can be achieved, with LASTNONBLANKVALUE or similar.

 

Please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services.