Forum Discussion
TcT85
Helper III
Helper IIICalculate from table1 measure with a table2 column
Hi, How can I calculate between 2 different tables if 1 is a measure and the other is a column? Table1 Measure Distinct count NG = CALCULATE ( DistinctCOUNT ( 'SPC DATA'[Barcode] ), 'SPC DA...
Hi amitchandak
I just managed to solve it. 😄
Boards OK =VARABC = CALCULATE( sum('Copy Input'[Total Inspected Boards]))VARDEF = CALCULATE( DISTINCTCOUNT( 'SPC DATA'[Barcode] ), 'SPC DATA'[OperatorJudgement] = "Ng" ) +0VARGHI = (ABC-DEF)ReturnGHI
amitchandak
Super User
Super UserTcT85 , You can subtract two measures from two tables and create a new measure. and view that at grand total level or against a common dimension
TcT85Helper III
Helper IIIHi amitchandak
I just managed to solve it. 😄
Boards OK =
VAR
ABC = CALCULATE( sum('Copy Input'[Total Inspected Boards]))
VAR
DEF = CALCULATE( DISTINCTCOUNT( 'SPC DATA'[Barcode] ), 'SPC DATA'[OperatorJudgement] = "Ng" ) +0
VAR
GHI = (ABC-DEF)
Return
GHI