Forum Discussion
Calculate multiple measures
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?
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
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
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.
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?