Forum Discussion

Shaun_Fourie's avatar
Shaun_Fourie
Frequent Visitor
1 year ago
Solved

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 ...
  • bhanu_gautam's avatar
    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.

  • Shaun_Fourie's avatar
    Shaun_Fourie
    1 year ago

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