Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
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
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.
Proud to be a Super User!
Hi @Edgar_massa;
Could you please share a pbix with some data so I can take a look?
Proud to be a Super User!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
87 | |
84 | |
68 | |
64 | |
63 |
User | Count |
---|---|
208 | |
120 | |
113 | |
79 | |
72 |