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))
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.