Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hey All – I need help creating a measure that will give me the right totals
I have a table that has Projects and then Project roles underneath
It has the total Working days in the contract (Max of ContractDays)
Each role has a rate
The Max of ContractRoleHours are the total hours in the contract
The Max of HrsPerDay is Max of ContractRoleHours / Max of ContractDays
The TotHoursPerDay is Max of HrsPerDay * Max of ContractDays
The TotDailyValue is Max of HrsPerDay * Rate
TotHrsPerDay Should = Max of ContractRoleHours. It does for some but not all. I know there are some filter and sum special logic needed in calculating some totals in matrix sometimes, but this is fairly straight forward and I used calculated columns for these values, so I thought it would work. I’m stuck on why it works for some and not all, (And also need to make it work 😊
Thanks in advance
Solved! Go to Solution.
I was able to solve my issue -thank you all.
Hi @ctedesco3307 ,
Has your problem been solved? If solved, please consider Accept it as the solution to help the other members find it more quickly.
Best regards,
Yadong Fang
I couldn't see where it works. However, in general you can do
SUMX (
SUMMARIZE ( 'Table', [Column1], [Column2] ),
CALCULATE ( the max aggregation )
)
where Column1 and Column2 are the columns placed in the rows of the matrix
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
31 | |
15 | |
14 | |
14 | |
9 |