I have a panel with a report that show the number of employees that the company has by gender, and I added a Competence Date filter (date referring to payrolls) but it is not working. "Competence Date" is linked to the "Payroll" dataset, which in turn is linked to the "Employees" dataset. How can I make this filter work?
Best answer by Joseph HeunView original
It sounds like you need to use a BY Clause to aggregate the data appropriately. The following is an older article which explains the concept of explicit lifting to connect the datasets. Please note that the images are outdated, but the modeling and MAQL principles are the same: