Calculate multiple measures

[Wiene24]

Hi,

I have multiple measures showing the amount of empty rows. 

Now I want one slicer that shows me the total of the measures, but it has to change when ever I change my slicers.

Aantal lege vakken is made with: 

Aantal lege vakken = [Vestiging]+[Functie]+[Afdeling]+[Tijdelijk type]+[Tijdelijk relatie]+[Straat]+[Huisnummer]+[Postcode]+[Woonplaats]+[Land]+[Prive telefoonnummer]+[Zakelijk telefoonnummer]+[Email]+[Geboortedatum]+[Geboorteplaats]+[Nationaliteit]+[Datum in dienst]+[BSN]+[BIC]+[IBAN]+[Paspoort]+[Paspoort datum]+[ADR]+[ADR datum]+[Bestuurderskaart]+[Bestuurderskaart datum]

I have tried this with calculate and with countblanks on all seperate columns but neither work.

Kind regards,

Tim Wijnen

[vanessafvg]

@Wiene24  when you say its not working what are you expecting?   what is your original measures made up of and doy want blanks to show there too?  are you able to share any data?

[Wiene24]

@vanessafvg they are all build with =COUNTBLANK(Column)

So I am counting for every column how many blanks there are, so I can do some research in how good people fill out the papers. With COUNTBLANK I can see wich fields aren't filled in every column.

Then I want a total of 'blanks' for the selected columns.

I can't really show data because it's very sensative for privacy.

Kind regards,

Tim Wijnen

[vanessafvg]

@Wiene24  so im still trying to understand what the problem is, the total added up measure adds up to too many records? ie it should be 1417 instead of 3199?  please tell me what figure you expecting.

i have tried to replicated the problem but i am unable to see what the problem is, mine adds up properly, its really hard to see what the issues is, do you have multiple tables with relationships?

can you show me your data structure?  i have attached my test, but in order to help i need more information from you 

[Wiene24]

@vanessafvg The problem is sololy that the number doesn't change when I use slicers.

The single ones do change but the total always stays 3199.

When I turn off all the slicers the number 3199 is correct, but when I put a slicer on it should go down, but it doesn't.

[vanessafvg]

@Wiene24  which slicers?   please give more information its really hard to help if you aren't able to give full information,  what is your table structure, is it one table?