Forum Discussion
AdiSarah55
1 year agoNew Member
Create comparison on same data source
HI, i really need your support, i'm strugling with many AI progrmas but still couldn't find the good answer. i have data table in powerbi looks like this: hash per build, with all tests verdicts ...
- 1 year ago
Hi AdiSarah55
follow this method
first create an unpivot table
unpivotnewtable = UNION( SELECTCOLUMNS( 'YourTable', "hash", 'YourTable'[hash], "build", 'YourTable'[build], "test", "test1", "verdict", 'YourTable'[test1 verdict], "actual", 'YourTable'[test1 actual] ), SELECTCOLUMNS( 'YourTable', "hash", 'YourTable'[hash], "build", 'YourTable'[build], "test", "test2", "verdict", 'YourTable'[test2 verdict], "actual", 'YourTable'[test2 actual] ), SELECTCOLUMNS( 'YourTable', "hash", 'YourTable'[hash], "build", 'YourTable'[build], "test", "test3", "verdict", 'YourTable'[test3 verdict], "actual", 'YourTable'[test3 actual] ) )and then create two separate table for build picks
first pick = DISTINCT(unpivotnewtable[build] )second pick = DISTINCT(unpivotnewtable[build] )and create this measure
Change Check = VAR FirstPickBuild = SELECTEDVALUE('first pick'[build]) VAR SecondPickBuild = SELECTEDVALUE('second pick'[build]) VAR FirstPickVerdict = CALCULATE ( MAX ( 'unpivotnewtable'[verdict] ), 'unpivotnewtable'[build] = FirstPickBuild, ALLEXCEPT('unpivotnewtable', 'unpivotnewtable'[hash], 'unpivotnewtable'[test]) ) VAR SecondPickVerdict = CALCULATE ( MAX ( 'unpivotnewtable'[verdict] ), 'unpivotnewtable'[build] = SecondPickBuild, ALLEXCEPT('unpivotnewtable', 'unpivotnewtable'[hash], 'unpivotnewtable'[test]) ) RETURN IF ( FirstPickVerdict = SecondPickVerdict, "0", "1" )and create two new tables in visual and add change check measure as a filter and for 1 table ask it to show 0 (not changed) and for other 1 (changed)
create two filter for the comparison between builds
v-pnaroju-msft
1 year agoCommunity Support
Hi AdiSarah55,
We are following up to see if your query has been resolved. Should you have identified a solution, we kindly request you to share it with the community to assist others facing similar issues.
If our response was helpful, please mark it as the accepted solution and provide kudos, as this helps the broader community.
Thank you.