For Power BI users, a problem often encountered is that they want to put the measure on the axis, but find that it cannot be achieved. Especially beginners want to do this habitually. Below I will give an example to explain this problem.

Basic situation: After a period of merchandise sales, a group of sales representatives will face performance evaluation.

The article is about dynamic calculation of contract status based on the updated dataset.