英文:
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 :
答案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],"")
示例:
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论