Forum Discussion
Table Report Measure Issue
- 1 year ago
Shaun_Fourie First Identify the value of TotalTimeLoggedOngoing for BancX
DAX
BancX_TotalTimeLoggedOngoing =
CALCULATE(
MAX('Final Time Allocation'[TotalTimeLoggedOngoing]),
'Final Time Allocation'[Customer] = "BancX"
)
Next, create a new calculated column that will fill the empty cells in TotalTimeLoggedOngoing with the value from BancX.
DAX
TotalTimeLoggedOngoing_Filled =
IF(
ISBLANK('Final Time Allocation'[TotalTimeLoggedOngoing]),
[BancX_TotalTimeLoggedOngoing],
'Final Time Allocation'[TotalTimeLoggedOngoing]
)
Use the new column in your report: Replace the TotalTimeLoggedOngoing column in your report with the new TotalTimeLoggedOngoing_Filled column. - 1 year ago
Resolved! Thank you so much for your time and assistance 🙂
Shaun_Fourie First Identify the value of TotalTimeLoggedOngoing for BancX
DAX
BancX_TotalTimeLoggedOngoing =
CALCULATE(
MAX('Final Time Allocation'[TotalTimeLoggedOngoing]),
'Final Time Allocation'[Customer] = "BancX"
)
Next, create a new calculated column that will fill the empty cells in TotalTimeLoggedOngoing with the value from BancX.
DAX
TotalTimeLoggedOngoing_Filled =
IF(
ISBLANK('Final Time Allocation'[TotalTimeLoggedOngoing]),
[BancX_TotalTimeLoggedOngoing],
'Final Time Allocation'[TotalTimeLoggedOngoing]
)
Use the new column in your report: Replace the TotalTimeLoggedOngoing column in your report with the new TotalTimeLoggedOngoing_Filled column.
- Shaun_Fourie1 year agoFrequent Visitor
Resolved! Thank you so much for your time and assistance 🙂