Disappearing values of Matrix rows when published on Power BI Portal?

[TungNguyen_19]

Hello everyone,

My current Power BI Desktop is Version: 2.114.864.0 64-bit (February 2023)

When I publish my Matrix from Power BI Desktop to Company workspace, everything is still fine but after a while the value of some rows are disapeared. All the fields are coming from the Calculated table which extract from normal table.

CalculatedTable_ = 
FILTER(
    ALL(PBI_EQUIPMENT_MOVEMENT_MASTER[EQPA_SERIAL_NO],
        PBI_EQUIPMENT_MOVEMENT_MASTER[EQPA_BL_NUMBER],
        PBI_EQUIPMENT_MOVEMENT_MASTER[EQPA_BOOKING_NUMBER],

And here is on Desktop. It show every rows I need

But on Workspace is different story

PLease help me, I have no idea what happen 😓 Does this error is from Microsoft or doing it wrong?

[v-rzhou-msft]

Hi @TungNguyen_19 ,

Here I couldn't reproduce your issue. Could you show me more details about your issue? This will make it easier for me to find the solution.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[TungNguyen_19 · Accepted solution]

Hi @v-rzhou-msft 

Yes I will describe it in following steps:

1/ I created the Matrix chart on Power BI Desktop and it has these rows and values:

- Rows are from the Calculated Table which extracted from the Direct Query SQL Table (I have no access to this). The DAX Code is here:

EXP_TABLE = 
FILTER(
    ALL(
        PBI_EQUIPMENT_MOVEMENT_MASTER[VESSEL],
        PBI_EQUIPMENT_MOVEMENT_MASTER[VOYAGE],
       ...
        PBI_EQUIPMENT_MOVEMENT_MASTER[CONTAINER],
       ...
        PBI_EQUIPMENT_MOVEMENT_MASTER[WEEK],
       ...
        PBI_EQUIPMENT_MOVEMENT_MASTER[F_BARGE_IMP_EXP]),
        PBI_EQUIPMENT_MOVEMENT_MASTER[EQPA_MOVE_CODE] = "LDFULL" &&
        PBI_EQUIPMENT_MOVEMENT_MASTER[F_BARGE_IMP_EXP] = "EXP")

- Values are a little bit complicated. I have to map them from 2 other tables, one for Total Cost and other for Total Revenue. The DAX code is here (same for both but different table)

Total Revenue = CALCULATE(VALUES('CSal'[_TOTAL REVENUE (USD)]), USERELATIONSHIP('EXP_TABLE'[ID_REVENUE], 'CSal'[ID]), 
                    ALLEXCEPT('EXP_TABLE ','EXP_TABLE '[ID_REVENUE], 'EXP_TABLE '[ID])) 

- The ID_REVENUE or ID are calculated columns.

2/ The Matrix show as I expected and I published it into my Pro license mode Workspace which of course I am the admin.

3/ On the workspace, the matrix still show exactly same the Desktop version BUT after a while these VESSEL and VOYAGE rows are disappeared (See the picture I have attached in this thread). It is weird 😶

I have updated my Desktop version to Version: 2.115.842.0 64-bit (March 2023) But the issue still happened.

Please give me any idea how to solve this.

Many thanks ❤️

[TungNguyen_19]

After a while this issues was disappeared with no reasons! I have no ideas, maybe use the lasted version or this error is related to Microsoft patch or something? Until now no one know and I have no clues so I will closed this right now and if anyone face this and have solution please just reply here. Many thanks for our community ❤️