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))
i created this calc:
test3 =
CALCULATE
(
SUM(Sheet1[Loan Count]),
ALLEXCEPT('Calendar Table','Calendar Table'[CalendarDate])
)
the calendar table looks like this:
and i am using a slicer now that uses the calendar date. However the same issue still exists - i.e. when i select a branch on the slicer, it changes the value.
😞
Also, why is a calendar table necessary? I appreciate the help!! Spent hours on this already...
Ashish_Mathur
Super User
Super UserShare the download link of the PBI file.
IT WORKED!!
That was exactly what i needed to do, thank you so much!!
The error i made was putting the wrong table name in the query...your suggestion was perfect.
THANKS SO MUCH!!- Ashish_Mathur
You are welcome.