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