Forum Discussion
Context transition
Hello Good morning everybody I have a problem here. The situation is very simple, I have a CNPJ from a company where 2 employees (cousins) work there and provide services to me, each month I compa...
Hi Edgar_massa,
So you mean you only want to calculate one time per group? According to the snapshot, the current records include two similar results per category.
For this scenario, I'd like to suggest you add an if statement to check the current row contents level, then you can divide 2 if current is calculate on the final result level.
Clever Hierarchy Handling in DAX - SQLBI
Regards,
Xiaoxin Sheng