Count in 2 related tables

[Ramyzo]

Greeting , 

i need a trick on Power BI with MDX. so i get 2 tables : Offer and appliaction 

Ex : 

Table Offer (offer ID , Offer Description ) :                                    Table Application (Offer ID ,  Candidat name )  : 

1 :OfferA                                                                                            1:Jason 

2: OfferB                                                                                             1:Tatum

3:OfferC                                                                                              1:Kyrie

4:OfferD                                                                                              2:Lebron

Ok so let's say i have those 2 tables first one contain offer ID's + description and second one contain the job ID + the candidat name 

I wanna get the numbers of offer that dont have a candidat yet ! in this example the result will be 2 ! ( Offer C and offer D )

Thanks in advance ! 

[kentyler · Accepted solution]

I copied your tables to excel and then imported them to power bi 

The form a simple star schema, with application as the fact table and offer as the dimension

I put field values on a matrix and added a single line calculated column to count the number of offers that had related applications.

The offers that have no applications show clearly.