Forum Discussion
Missing total distinguished count
Syndicate_Admin
So what is your requirement ?
My requirement is that the individual summaries of each table correspond to the total, as can be seen in each table the total is 5356 when adding Female+Male, FILE+BIBLIOTECA+BODEGA+GYM or Advisory+claim+complain+conference+etc. does not match the total with the summations. and so if it results in a distinctive result 5356 in general the sum should match that total.
Thank you!
Syndicate_Admin
That is the way it works 🙂
At the total level, it takes all the values and gets the DISINCTCOUNT. It does not add up the other "cells" .
If you want to get the desired results, you need to add each row as follows. I only did it for office, you will need to create for each category where you need DISTINCTCOUNT.Measure = IF( ISINSCOPE( Example_catered[office]), DISTINCTCOUNT(Example_catered[Cod]), var __t = ADDCOLUMNS(ALLSELECTED(Example_catered[office]),"@dcount", CALCULATE(DISTINCTCOUNT(Example_catered[Cod]))) return SUMX(__t,[@dcount]) )Yes, it is correct what you are asking me, but if I show a distinctive total result of 5356 which is the distinctive global, the sums of the offices, for example, open me up to 5356.
Because the reference value is that total, if the summation throws 5926 would be exceeding the actual value of the badge which is 5356, it is as if it counts more additional cells, it is loq eu I wish to avoid, otherwise without the distinctiveness and repeated values in the cells there are equalizations the sums. There is a date value for events in the main table, and dates may be repeated, that field type may increase or deter from the total, because dates do not behave as an ID.
