最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

powerbi - power bi complex dax - Stack Overflow

programmeradmin0浏览0评论

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
发布评论

评论列表(0)

  1. 暂无评论