Calculate from table1 measure with a table2 column

[TcT85]

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 DATA'[OperatorJudgement] = "Ng" ) +0

Table 2 Column

Product	Quantity
A	400
B	200

I want to substract the Ng count from table1  with quantity produced in table2.

[amitchandak]

@TcT85 , 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

https://amitchandak.medium.com/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solutio...

[TcT85 · Accepted solution]

Hi 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