Forum Discussion
Joined Data Repeats SUM for Each Line
Hello, As this is my first post, please pardon me if it's not quite the standard, but I promise to adapt and catch up quick. I performed a search on other forums within the Power BI message board...
v-chuncz-msft
Community Support
Community Support
You could use the following DAX to add a meausre.
Measure =
VAR ProjectId =
MAX ( Table1[Project#] )
RETURN
CALCULATE (
SUM ( Table2[Billed] ),
FILTER ( Table2, Table2[SER#] = ProjectId )
)
Greetings,
Thank you. I'll create & incorporate this measure into my query this morning & provide the results. The DAX makes sense as it should return the Max Value (*SUM) of the column (ie. if John is billing $150 for 5 business days, it should return SUM of $150 & not SUM of total billed for all resources).
Many regards,
Byron D
Thank you. I'll create & incorporate this measure into my query this morning & provide the results. The DAX makes sense as it should return the Max Value (*SUM) of the column (ie. if John is billing $150 for 5 business days, it should return SUM of $150 & not SUM of total billed for all resources).
Many regards,
Byron D