Uncategorized

DAX: calculating maximum period of LSA non-compliance from individual probe readings

The Problem The contractor has to maintain the values of n probes under a certain threshold.Data is measured each 5 minutes, 24 hours per day.An incident is defined as the period while a probe readings are continuously over the thresholdLSA is based on the number of incidents in a month, and the maximum period of …

DAX: calculating maximum period of LSA non-compliance from individual probe readings Read More »

Context Propagation details and other surprises while doing a ranking calculation

During my PowerBI courses, one of the topics that presents the most difficulties and surprises for the participants is to understand what the evaluation context is, what is the row context, the filter context, and above all, the propagation of contexts. Microsoft, as it usually does for its popular products, hides internal complexities to “facilitate” …

Context Propagation details and other surprises while doing a ranking calculation Read More »