Context transition

[Edgar_massa]

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 compare the contract hour, contract value with what they are issuing in the invoice for me to pay .

I have a table where the contract per employee brings the sum of value and hour etc.. however, in the result of the table, I would like it to only add the contract value/contract hour once, as I add up the hours of the contract with the legal entity, and not the employees of that company

How do I change the context of the calculation to the final result in the table?

I need you to bring me the result of 181.87 + 176 and not 715.73

[Anonymous]

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

[Edgar_massa]

@_AAndrade 

[_AAndrade]

Hi @Edgar_massa,

I already took a look at your file but I can't understand your model yet. You have a huge Dax measure because the way you build your model.

[_AAndrade]

Hi @Edgar_massa;

Could you please share a pbix with some data so I can take a look?

[Edgar_massa]

@_AAndrade 

https://drive.google.com/drive/folders/1ctq95PNnQDhjDVqDRKHPwoSV39vYMsJY?usp=sharing