HELP WITH DAX IGNORING TABLE RELATIONSHIP

[Anonymous]

SOME HELP PLEASE: (PBIX LINK): https://www.dropbox.com/s/ypxv1ift10e5v8q/BI%20VISITAS%20DEMO%20QUERY.pbix?dl=0

I have the following dax: 

MPP HC = CALCULATE(COUNTA('dotacion (3)'[ID. HR]);
'dotacion (3)'[PUESTO] IN {"VendedorEspecialistaenSeguridad";"VendedorExpertoenSeguridad"};
ALL('dotacion (3)'[ID. HR]))

 This DAX in my model counts in the column "ID.HR" BY 2 types of job positions out of 6 in the Column "PUESTO" and the idea is to count them and divide for "Demo quantity"  in 21 differents departments. ex:

Department 1 has 5 positions/ 5 DEMOS

Department 2 has 6 positions/30 DEMOS

Department 3 has 4 positions/ 45 DEMOS AND SO ON...

The desired result is to divide the DEMO Quantity of each department by the total of these 2 types of job positions as head counts. the problem is that for some reason is not dividing by the total of these 2 job positions they are less and I cant find the filter this model is applying. For example:

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

For the 1st question, To create a new measure as below.

MPP HC2 = IF(SUM(PBI[Total]) = BLANK(),BLANK(),CALCULATE(COUNTA('dotacion (3)'[ID. HR]),ALL(PBI),'dotacion (3)'[PUESTO]IN {"VendedorEspecialistaenSeguridad","VendedorExpertoenSeguridad"}))

For the 2rd one, to update your measure like this.

MPP HC = CALCULATE(COUNTA('dotacion (3)'[ID. HR]),'dotacion (3)'[PUESTO] IN {"VendedorEspecialistaenSeguridad","VendedorExpertoenSeguridad"},ALL('dotacion (3)'))