admin管理员组

文章数量:1356808

i have this table in power bi: results=

hash    build   cycle   test    outcome
1234    1   nightly a   passed
1234    2   weekly  a   passed
1234    2   nightly a   passed
2345    1   nightly a   failed
2345    2   weekly  a   passed
2345    2   nightly a   passed
1234    1   nightly b   passed
1234    2   weekly  b   passed
1234    2   nightly b   failed
2345    1   nightly b   failed
2345    2   weekly  b   passed
2345    2   nightly b   passed

i have also 2 measures:

firstPick = 
SUMMARIZE(
    results,
    results[build],
    results[cycle]
)
secondPick = 
SUMMARIZE(
    results,
    results[build],
    results[cycle]
)

in firstpick i choose cycle and build, and also on secondpick, the mission is to compare between same tests outcome on each hash for example i pick: firstpick = 2(build) weelky(cycle) and seconfpick = 2(build) nightly(cycle) so this is what should i compare:

hash    build   cycle   test    outcome
1234    2   weekly  a   passed
1234    2   nightly a   passed
2345    2   weekly  a   passed
2345    2   nightly a   passed
1234    2   weekly  b   passed
1234    2   nightly b   failed
2345    2   weekly  b   passed
2345    2   nightly b   passed

each hash on each test so eventually i will have the below data becuase for example test b on hash 1234 once passed and once failed so i want to create 4 tables like this: same results on build 2 cycle nightly:

hash    build   cycle   test    outcome
1234    2   nightly a   passed
2345    2   nightly a   passed
2345    2   nightly b   passed

same results on build 2 cycle weekly:

hash    build   cycle   test    outcome
1234    2   weekly  a   passed
2345    2   weekly  a   passed
2345    2   weekly  b   passed

not same results on build 2 cycle nightly:

hash    build   cycle   test    outcome
1234    2   nightly b   failed

not same results on build 2 cycle weekly:

hash    build   cycle   test    outcome
1234    2   weekly  b   passed

本文标签： powerbipower bi complex daxStack Overflow

版权声明：本文标题：powerbi - power bi complex dax - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1743991477a2572221.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。