Forum Discussion
ALLEXCEPT Not Working - should i use something else?
i have a very simple table that i wrote a custom sql statement for. no relationships, just a single table - purpose was to test this. i am trying to do the equivalent of a fixed calc form tableau...
Hi,
Create a Calendar Table and to your slicer/filter/visual, drag Date from the Calendar Table. Create a relationship (many to one and single) from the Disbursement date to the Date column of the Calendar Table. Write this measure
test fixed loan count = CALCULATE(SUM(Query1[LoanCount]),ALLEXCEPT(Calendar))
so i added .[date] after disbursement date and that got rid of the issue where it wasnt ignoring the branch filter (i.e. now it does).
BUT
Now its also ignoring the disbursementdate filter! So it pulls the count for the entire dataset time period.
😞 😞 😞 😞