Matrix Errors When Collapsing Column

[TayTay]

This is a repost from the Desktop forum as I think it might be an issue. My apologies if that's not allowed.

My PBI Desktop version is 2.131.1203.0 64-bit. The same behaviour is also happening in the online service if I publish.

I've got a simple table that I'm displaying in a Matrix, if I expand then collapse a column the matrix errors and is not displayed.

The table query has two custom M columns, one is quantity and the other unit.

Blank and errored quantity is removed. There are no other transformations and no DAX columns or measures.

Item Number, Unit, Type and Warehouse are all formatted as text, Quantity is a decimal number and Physical Month is a date.

The Matrix visual is collapsed on Type to show overall quantity.

When expanding to warehouses, some rows cause the visual to scroll up and away from the expanded row. When this happens the visual will error if the row is collapsed again. Giving error "DAX comparison operations do not support comparing values of type Text with values of type True/Fales. Consider using the VALUE or FORMAT function to convert one of the values."

Applying then clearing any filter fixes the issue and the visual will load.

Here is a video showing the behaviour.

[Anonymous]

Hi @TayTay 

The problem should be in your filter conditions. If without any DAX applied. You need to check if your filter conditions are comparing or filtering fields of different data types, causing the error to be reported. Also you mentioned two custom columns, how is this custom column set up?

Best Regards,
Community Support Team _ Ailsa Tao

[TayTay]

Hi @Anonymous 
There are no filters applied to the visual and the only columns that aren’t text are Month and Quantity. I show there are no filters on the visual at 0:02 of the video.

The two custom columns are created in query using M. Some items are 2 packs so for easier comparison I've converted them into eaches.

Custom Quantity column is:
#"Added Quantity" = Table.AddColumn(Source, "Quantity", each if [Base Unit] = "Double"
then [Base Quantity] * 2
else [Base Quantity]),

Custom Unit column is:
#"Added Unit" = Table.AddColumn(#"Added Quantity", "Unit", each if [Base Unit] = "Double"
then "ea"
else [Base Unit]),