适用于：
计算列 计算表 度量值 视觉计算 
DAX 查询
返回一个表，其中包含有关语义模型中每个批注的信息。 此信息可帮助你了解模型。
语法
INFO.ANNOTATIONS ( [<Restriction name>, <Restriction value>], ... )
参数
此 DAX 函数的参数是可选的。 使用参数时，必须同时提供这两个参数。 允许多个参数对。 限制名称和值是文本，以双引号输入。
| 术语 | 定义 |
|---|---|
| 限制名称 | 用于筛选结果的限制的名称。 |
| 限制值 | 用于筛选限制结果的值。 |
限制
通常，DAX 函数结果的所有列都可以用作限制。 还可以允许其他限制。
返回值
具有以下列的表：
| 列 | 描述 |
|---|---|
| [ID] | 对对象的引用。 ID 通常是自动生成的，在创建模型后不应更改。 数据类型为无符号长 （4 个字节）。 |
| [ObjectID] | 对拥有此批注的对象的引用。 |
| [ObjectType] | 对拥有此批注的对象类型的引用。 |
| [名称] | 对象的名称，用于代码、脚本和查询。 |
| [值] | 批注的值。 |
| [ModifiedTime] | 上次修改对象的时间。 |
言论
只能由对语义模型具有写入权限的用户运行，而不能在 Power BI Desktop 中实时连接到语义模型时运行。 此函数可用于 DAX 查询，并且不能用于计算。
示例 1 - DAX 查询
可以在 DAX中运行以下 DAX 查询：
EVALUATE
INFO.ANNOTATIONS()
此 DAX 查询返回包含此 DAX 函数的所有列的表。
示例 2 - 使用联接 DAX 查询
可以在 DAX中运行以下 DAX 查询：
EVALUATE
VAR _ObjectTypeEnum =
DATATABLE(
"ObjectType",INTEGER,
"Object",STRING,
{
{0,"Null"},
{1,"Model"},
{2,"DataSource"},
{3,"Table"},
{4,"Column"},
{5,"AttributeHierarchy"},
{6,"Partition"},
{7,"Relationship"},
{8,"Measure"},
{9,"Hierarchy"},
{10,"Level"},
{11,"Annotation"},
{12,"KPI"},
{13,"Culture"},
{14,"ObjectTranslation"},
{15,"LinguisticMetadata"},
{29,"Perspective"},
{30,"PerspectiveTable"},
{31,"PerspectiveColumn"},
{32,"PerspectiveHierarchy"},
{33,"PerspectiveMeasure"},
{34,"Role"},
{35,"RoleMembership"},
{36,"TablePermission"},
{37,"Variation"},
{38,"Set"},
{39,"PerspectiveSet"},
{40,"ExtendedProperty"},
{41,"Expression"},
{42,"ColumnPermission"},
{43,"DetailRowsDefinition"},
{44,"RelatedColumnDetails"},
{45,"GroupByColumn"},
{46,"CalculationGroup"},
{47,"CalculationItem"},
{48,"AlternateOf"},
{49,"RefreshPolicy"},
{50,"FormatStringDefinition"}
}
)
VAR _INFO =
INFO.ANNOTATIONS()
VAR _CombinedTable =
NATURALLEFTOUTERJOIN(
_INFO,
_ObjectTypeEnum
)
VAR _ModelObjects =
UNION(
SELECTCOLUMNS(
INFO.MEASURES(),
"ObjectID", [ID],
"Object Name", [Name]
),
SELECTCOLUMNS(
INFO.TABLES(),
"ObjectID", [ID],
"Object Name", [Name]
),
SELECTCOLUMNS(
INFO.COLUMNS(),
"ObjectID", [ID],
"Object Name", [ExplicitName]
),
SELECTCOLUMNS(
INFO.EXPRESSIONS(),
"ObjectID", [ID],
"Object Name", [Name]
),
SELECTCOLUMNS(
INFO.MODEL(),
"ObjectID", [ID],
"Object Name", [Name]
)
)
VAR _CombinedTable2 =
NATURALLEFTOUTERJOIN(
_CombinedTable,
_ModelObjects
)
RETURN
SELECTCOLUMNS(
_CombinedTable2,
"Object type", [Object],
"Object", [Object Name],
"Annotation name", [Name],
"Annotation value", [Value]
)
ORDER BY [Annotation name]
此 DAX 查询仅返回具有指定列的表，并联接到其他 INFO DAX 函数和枚举表。
枚举
此 INFO 函数中返回的列提供枚举或查阅表的 ID。 下面是此 DAX 函数中每个枚举的值。
ObjectType
| 数 | 价值 |
|---|---|
| 0 | 零 |
| 1 | 型 |
| 2 | DataSource |
| 3 | 桌子 |
| 4 | 列 |
| 5 | AttributeHierarchy |
| 6 | 分区 |
| 7 | 关系 |
| 8 | 量 |
| 9 | 等级制度 |
| 10 | 水平 |
| 11 | 注解 |
| 12 | KPI |
| 13 | 文化 |
| 14 | ObjectTranslation |
| 15 | LinguisticMetadata |
| 29 | 透视 |
| 30 | PerspectiveTable |
| 31 | PerspectiveColumn |
| 32 | PerspectiveHierarchy |
| 33 | PerspectiveMeasure |
| 34 | 角色 |
| 35 | RoleMembership |
| 36 | TablePermission |
| 37 | 变化 |
| 38 | 设置 |
| 39 | PerspectiveSet |
| 40 | ExtendedProperty |
| 41 | 表达 |
| 42 | ColumnPermission |
| 43 | DetailRowsDefinition |
| 44 | RelatedColumnDetails |
| 45 | GroupByColumn |
| 46 | CalculationGroup |
| 47 | CalculationItem |
| 48 | AlternateOf |
| 49 | RefreshPolicy |
| 50 | FormatStringDefinition |
若要与 INFO 函数联接，请使用此 DAX 查询。
EVALUATE
DATATABLE(
"ObjectType",INTEGER,
"Object",STRING,
{
{0,"Null"},
{1,"Model"},
{2,"DataSource"},
{3,"Table"},
{4,"Column"},
{5,"AttributeHierarchy"},
{6,"Partition"},
{7,"Relationship"},
{8,"Measure"},
{9,"Hierarchy"},
{10,"Level"},
{11,"Annotation"},
{12,"KPI"},
{13,"Culture"},
{14,"ObjectTranslation"},
{15,"LinguisticMetadata"},
{29,"Perspective"},
{30,"PerspectiveTable"},
{31,"PerspectiveColumn"},
{32,"PerspectiveHierarchy"},
{33,"PerspectiveMeasure"},
{34,"Role"},
{35,"RoleMembership"},
{36,"TablePermission"},
{37,"Variation"},
{38,"Set"},
{39,"PerspectiveSet"},
{40,"ExtendedProperty"},
{41,"Expression"},
{42,"ColumnPermission"},
{43,"DetailRowsDefinition"},
{44,"RelatedColumnDetails"},
{45,"GroupByColumn"},
{46,"CalculationGroup"},
{47,"CalculationItem"},
{48,"AlternateOf"},
{49,"RefreshPolicy"},
{50,"FormatStringDefinition"}
}
)