Forum Discussion

Wiene24's avatar
Wiene24
Helper II
7 years ago

Calculate multiple measures

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
Need Help

5 Replies

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    7 years ago

    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's avatar
      Wiene24
      Helper II
      7 years ago

      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's avatar
        vanessafvg
        Community Champion
        7 years ago

        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