Forum Discussion
Table Report Measure Issue
Hi! So I have the below table report in my Power Bi report namely Final Time Allocation.
Notice that the TotalTimeLoggedOngoing cells for Avbob and Float are empty, I want to make every other cell in TotalTimeLoggedOngoing equal to the same as whatever BancX equals.
Is there a way that I can do this? Please assist.
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.Resolved! Thank you so much for your time and assistance 🙂
2 Replies
- bhanu_gautam
Super User
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.Resolved! Thank you so much for your time and assistance 🙂