从另一个数据集Power BI的记录中搜索列

Question

我有一个由46个不同国家名称组成的数据集。我有另一个数据集，国家是其中一列。我想多找一些不属于这46个国家的国家。我想使用DAX函数来完成它，但不知道如何进一步进行。我是Power BI的新手，正在寻求您的建议。

Answer 1

这46个不同的国家/地区是否位于源表的一列中？在没有样本数据的情况下，按照我的理解方式(如果我错了，请纠正我(，考虑到我想象的源数据的结构，使用Power Query会更容易实现这一点

/*_dim*/
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCg1WitUBUt5gytnRTyk2FgA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Country = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Country", type text}})
in
#"Changed Type"

/*_fact*/
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUXIEEU4gwhlEuBgqxcYCAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [SN = _t, US = _t, UK = _t, CAN = _t, AUS = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"SN", Int64.Type}, {"US", type text}, {"UK", type text}, {"CAN", type text}, {"AUS", type text}}),
Custom1 = Table.DemoteHeaders(#"Changed Type"),
#"Changed Type1" = Table.TransformColumnTypes(Custom1,{{"Column1", type any}, {"Column2", type text}, {"Column3", type text}, {"Column4", type text}, {"Column5", type text}}),
#"Transposed Table" = Table.Transpose(#"Changed Type1"),
#"Merged Queries" = Table.NestedJoin(#"Transposed Table", {"Column1"}, _dim, {"Country"}, "_dim", JoinKind.LeftAnti),
#"Removed Columns" = Table.RemoveColumns(#"Merged Queries",{"_dim"}),
#"Transposed Table1" = Table.Transpose(#"Removed Columns"),
#"Promoted Headers" = Table.PromoteHeaders(#"Transposed Table1", [PromoteAllScalars=true]),
#"Changed Type2" = Table.TransformColumnTypes(#"Promoted Headers",{{"SN", Int64.Type}, {"AUS", type text}})
in
#"Changed Type2"