自定义矩阵标题 [英] Custom matrix header
问题描述
我需要创建一个自定义标题,如下图所示:
我检查此链接
编辑
Dim_prduit
我的问题是如何分配Nombre产品,然后喜欢
这很丑陋,但是您可以编写这样的标题表,然后定义一个转换措施根据相应的索引:
标题=
加列(
UNION(
DATATABLE(
顶部,STRING,
索引1,整数,
中间,STRING,
索引2,整数,
底部,STRING,
Index3,整数,
{
{ Nombre product,1,,0,,0},
{ Affaires nouvelles,2, 总计,8,,0},
{ Affaires nouvelles,2,%Total,9,,0}
}
),
SELECTCOLUMNS(
SUMMARIZECOLUMNS(Dim_Prod [dim5],Dim_Prod [ dim6]),
顶部, Affaires nouvelles,
Index1,2,
中间,Dim_Prod [dim5],
Index2,RANK。 EQ(Dim_Prod [dim5],Dim_Prod [dim5],ASC),
底部,Dim_Prod [dim6],
Index3,RANK.EQ(Dim_Prod [dim6],Dim_Prod [dim6])
)
),
Index0,100 * [Index1] + 10 * [Index2] + [Index3]
)
输出:
样本量度:
样本量度=
VAR Top = SELECTEDVALUE(Header [Top])
VAR Middle = SELECTEDVALUE(Header [Middle])
VAR BottomIndex = SELECTEDVALUE(Header [Index3])
返回
开关(
TRUE(),
顶部= Nombre产品,[NombreProductMeasure],
顶部= Affaires nouv elles&& BottomIndex<> 0,[DimensionMeasure],
Middle = Total,[TotalMeasure],
Middle =%Total,[%TotalMeasure]
)
虽然这很hacky。 Power BI可能不是此处的最佳工具。
I need to create a custom header like the picture below:
I check this link Custom aggregate column in power bi matrix But I don't undestand how to do the same to my case?
Edit
I try to create calculated table but I didn't get the data for dim5 and dim6, how can I modify it?
Edit
Dim_prduit
My problem is how to dispaly Nombre product , and then like hierarchy dim5 then dim6 in the header?
It's ugly but you can write a header table like this and then define a switching measure based on the appropriate indices:
Header =
ADDCOLUMNS (
UNION (
DATATABLE (
"Top", STRING,
"Index1", INTEGER,
"Middle", STRING,
"Index2", INTEGER,
"Bottom", STRING,
"Index3", INTEGER,
{
{ "Nombre product", 1, "", 0, "", 0 },
{ "Affaires nouvelles", 2, "Total", 8, "", 0 },
{ "Affaires nouvelles", 2, "%Total", 9, "", 0 }
}
),
SELECTCOLUMNS (
SUMMARIZECOLUMNS ( Dim_Prod[dim5], Dim_Prod[dim6] ),
"Top", "Affaires nouvelles",
"Index1", 2,
"Middle", Dim_Prod[dim5],
"Index2", RANK.EQ ( Dim_Prod[dim5], Dim_Prod[dim5], ASC ),
"Bottom", Dim_Prod[dim6],
"Index3", RANK.EQ ( Dim_Prod[dim6], Dim_Prod[dim6] )
)
),
"Index0", 100 * [Index1] + 10 * [Index2] + [Index3]
)
Output:
Sample measure:
SampleMeasure =
VAR Top = SELECTEDVALUE ( Header[Top] )
VAR Middle = SELECTEDVALUE ( Header[Middle] )
VAR BottomIndex = SELECTEDVALUE ( Header[Index3] )
RETURN
SWITCH (
TRUE (),
Top = "Nombre product", [NombreProductMeasure],
Top = "Affaires nouvelles" && BottomIndex <> 0, [DimensionMeasure],
Middle = "Total", [TotalMeasure],
Middle = "%Total", [%TotalMeasure]
)
This is pretty hacky though. Power BI may not be the best tool here.
这篇关于自定义矩阵标题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!