Table Report Measure Issue

[Shaun_Fourie]

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.

[bhanu_gautam · Accepted solution]

@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.

[bhanu_gautam · Accepted solution]

@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_Fourie · Accepted solution]

Resolved! Thank you so much for your time and assistance 🙂