如何在矩阵折叠时隐藏数值?

huangapple go评论65阅读模式
英文:

How can I hide the values in matrix when it is collapsed?

问题

我试图创建矩阵视图。当我展开它时,值不像预期的那样显示在顶部,但当我折叠它时,我仍然得到值。这些值没有意义,所以想要隐藏它们。我尝试了isinscope函数,但无法隐藏这些值。我想要隐藏黄色高亮显示的数据。请注意,我已经展示了我正在使用的度量:

我使用了以下度量 = if (ISINSCOPE(CAA_KPI_TOPIC[Topic]),[度量 2],blank()),但这没有解决问题。

我计算了度量 2 如下:

度量 2 = Sum(CAA_KPI_DATA[DATA])

任何帮助将不胜感激。

谢谢,

Sam

请在此处找到pbix文件:

这是我得到的结果:

英文:

I am trying to create matrix view. When I have it expanded, value doesn't show at the top as expected however, when I collapse it I keep getting values. These value makes no sense so would like to hide. I tried isinscope function but couldn't hide the values. I would like to hide yellow highlighted data. Please note I have shown measure I am using:

I used Measure = if (ISINSCOPE(CAA_KPI_TOPIC[Topic]),[Measure 2],blank()) but this didn't solve the issue.

如何在矩阵折叠时隐藏数值?

I calculated Measure 2 as

Measure 2 = Sum(CAA_KPI_DATA[DATA])

Any help would be appreciated.

Thank you,

Sam

Please find pbix file here:

This is the result I get :

如何在矩阵折叠时隐藏数值?

https://file.io/zHeOvTbz1JYz

答案1

得分: 0

修正您的度量

度量 = 如果 (ISINSCOPE(CAA_KPI_TOPIC[主题]), 空白(), [度量 2])

英文:

Correct your measure

Measure = if (ISINSCOPE(CAA_KPI_TOPIC[Topic]),blank(),[Measure 2])

答案2

得分: 0

ISINSCOPE应该使用第二行,所以将[topic]更改为[kpis_name]:

Measure = if (ISINSCOPE(CAA_KPI_KPIS[KPIS_NAME]),[Measure 2],"")

示例:

如何在矩阵折叠时隐藏数值?

英文:

ISINSCOPE should use the second rows, so change [topic] into [kpis_name]:

Measure = if (ISINSCOPE(CAA_KPI_KPIS[KPIS_NAME]),[Measure 2],"")

Sample:

如何在矩阵折叠时隐藏数值?

huangapple
  • 本文由 发表于 2023年7月14日 05:35:57
  • 转载请务必保留本文链接:https://go.coder-hub.com/76683387.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定