Using Two Columns to get data

[selpaqm]

Hi,

I have a strange table and cannot get logic how to make it. Please check below table and what I need.

Customer	Product	Test Result	extras	Result
AAA	xxx	Pass		1
BBB	yyy	Pass	xxx	1
AAA	zzz	Fail	xxx	0
CCC	xxx	Fail		0

now, I want to see that to create a measure and see test result percentage by product. if has no data on extras column there is no issue. however, for example for customer BBB there are two products yyy and xxx (it comes from extras column) so always pass affects both extras and product column result. 

in case I want to see yyy product pass rates it is ok 1 check and it passed. for zzz is same logic. but for xxx one I could not calculate the pass rate. the result should be for xxx is on product column there are 2 xxx and one failed and one passed, for extras column same on xxx so result should be 2/4=50%.  table at the report should look like 

Product	pass rate
xxx	50% (4 check 2 passed 2 failed)
yyy	100%
zzz	0%

and I will use this measure for both customers' products etc.

[Bmejia · Accepted solution]

You can unpivot the data during the transformation so the two columns Product and extras are in one column. 
So you go from your original table above  to this:

Then just create a measure that divides number count of the total "Value" by total value results where it passed or 1.

PassRate =

VAR AllCount =  COUNTROWS(StrangeTable)

VAR PassCount = CALCULATE(COUNTROWS(StrangeTable),StrangeTable[Result ]=1)

RETURN

DIVIDE(PassCount ,AllCount,0)+0