You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
M Query for example table.
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjQyVtJRCkpNAZIhRaWpQMotMac4VSk2FgA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Key = _t, Type = _t, Field1 = _t, field2 = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"field2", type logical}, {"Field1", type logical}})
in
#"Changed Type"
Tabular Editor 3 Version
3.18
Screenshots
Steps to Reproduce
Clicked on 'Table'[Type] row to use code action.
Expected behavior
This should split the filters instead of delete
Crash Report
No response
Windows Version
Windows 10 Enterprise
The text was updated successfully, but these errors were encountered:
Description
Using the code actions "Split multi-column filter into multiple filters" deletes filters in this certain case.
Code used.
CALCULATE (
DISTINCTCOUNT ( 'Table'[Key] ),
'Table'[Type]
IN { "Red", "Blue" }
&& 'Table'[Field1] = FALSE ()
&& 'Table'[field2] = FALSE ()
)
M Query for example table.
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjQyVtJRCkpNAZIhRaWpQMotMac4VSk2FgA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Key = _t, Type = _t, Field1 = _t, field2 = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"field2", type logical}, {"Field1", type logical}})
in
#"Changed Type"
Tabular Editor 3 Version
3.18
Screenshots
Steps to Reproduce
Clicked on 'Table'[Type] row to use code action.
Expected behavior
This should split the filters instead of delete
Crash Report
No response
Windows Version
Windows 10 Enterprise
The text was updated successfully, but these errors were encountered: