screenshot-2023-08-24-221712.jpg
screenshot-2023-08-24-221757.jpg
I'm trying to create a condition on Headcount measure using a data action that if the headcount is not equal to 1, the data action will delete the value and also if FTE < 0, then put a 1 on the headcount. And if FTE = 0, then delete the headcount.
On the table, the headcount values (both empty and 1) are shown properly against FTE. But if I remove the FTE and only put HeadCount in the table against employees, it only shows the 1 values and not the empty values. Why is this happening?