PowerBI百分比计算
PowerBI百分比计算
提问于 2020-09-07 11:19:20
Team ID FRUIT
Team1 ID1 apple
Team1 ID2 apple
Team1 ID4 apple
Team1 ID5 apple
Team1 ID6 apple
Team1 ID7 apple
Team1 ID9 apple
Team2 ID11 apple
Team2 ID13 apple
Team2 ID14 apple
Team2 ID15 apple
Team2 ID17 apple
Team1 ID1 pear
Team1 ID4 pear
Team1 ID5 pear
Team1 ID8 pear
Team2 ID13 pear
Team2 ID15 pear
Team2 ID16 pear
Team2 ID17 pear
Team2 ID18 pear
Team2 ID19 pear
Team2 ID20 pear
Team1 ID1 strawberry
Team1 ID5 strawberry
Team2 ID20 strawberry
Team1 ID3
Team1 ID7
Team1 ID9
Team1 ID10
Team2 ID12我尝试在PowerBI中计算:在每个团队中，不同ID的百分比具有每种类型的水果。(水果变量为空的行需要保留，因为有些IDs没有水果数据，但需要计入分母)
我的预期结果是：
Team1 apple 70%
Team2 apple 50%
Team1 pear 40%
Team2 pear 70%
Team1 strawberry 20%
Team2 strawberry 10%
Team1 40%
Team2 10%我用了下面的方法，但是不起作用，有没有人可以帮助我？谢谢。
Measure =
CALCULATE(
DISTINCTCOUNT(Sheet1[ID]),
GROUPBY(
Sheet1,
Sheet1[FRUIT]
)
)/
CALCULATE(
DISTINCTCOUNT(Sheet1[ID]),
GROUPBY(
Sheet1,
Sheet1[TEAM]
)
)回答 1
Stack Overflow用户
回答已采纳
发布于 2020-09-07 13:00:48
你可以尝试下面的措施来达到你的目的。只需使用菜单栏将度量类型更改为%-
team_wise_percentage =
VAR total_distinct_id =
CALCULATE(
DISTINCTCOUNT(Sheet1[ID]),
FILTER(
ALL(Sheet1),
Sheet1[Team] = MIN(Sheet1[Team])
)
)
VAR total_distinct_id_for_current_row_fruit =
CALCULATE(
DISTINCTCOUNT(Sheet1[ID]),
FILTER(
ALL(Sheet1),
Sheet1[Team] = MIN(Sheet1[Team])
&& Sheet1[FRUIT] = MIN(Sheet1[FRUIT])
)
)
RETURN total_distinct_id_for_current_row_fruit/total_distinct_id这是最终的输出-
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/63770887
复制相关文章
相似问题
腾讯云开发者
